Build 3.5.0.14 of xlsgen adds rendering of color scales in print, print preview, PDF, ...

Color scales are conditional formattings that were introduced in Excel 2007. It allows to set the background of a cell dynamically based on some predefined rule. Excel 2007 and more recent versions of Excel support 2-color scales and 3-color scales, which means these are color scales made of respectively 2 and 3 color stops. For example, a color scale made of 2 color stops such as red and blue, will compute shades of red and blue across the entire range where conditional formatting applies.

xlsgen adds a little more to this. If the conditional formatting in question is created with xlsgen itself instead of manually in Excel, then you can create n-color scales, which means as many color stops you need.

In any case, xlsgen takes care of all the color shades between color stops, so you do not have to worry about all this.

Below are examples of 2 and 3 color scales.

Color scales can be used in business intelligence for visual alerts.


Rendering conditional formatting color scales in xlsgen