David Lai's Business Intelligence Blog

Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing. Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object. Basically if the initial binding color of a cell was “Green”, it would stay green even though it were to change to “Red” when the value changes.

Please view my video on how to simply accomplish this using a grid component in Xcelsius

Please visit my post on “MyXcelsius” for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and charts.

You can download the source file for the example here