Adding 2-Color Scale and 3-Color Scale Conditional Formattings
Contents
[
Hide
]
2-Color Scale and 3-Color Scale Conditional Formattings are added in the same way except they are differed by ColorScale.setIs3ColorScale(boolean) method. This method is false for 2-Color Scale and true for 3-Color Scale Conditional Formattings.
The following sample code adds 2-Color and 3-Color Scale Conditional Formattings. It generates the output excel file.