Conditional formatting
TM1® Web supports Excel conditional formatting,
including color scale conditional formatting, and icon sets.
- Icon set conditional formatting
- With icon set conditional formatting, each icon represents a range of values. If color icons are used, the color of the icons represents a comparison of the values across the grid. Low values are red, medium values are yellow, and high values are green.
- Color scale conditional formatting
- With color scale conditional formatting, colors are shaded with gradations of two or three colors according to the value across the grid.
Note: When you use icon set or color scale conditional formatting in an Active Form, place the
formatting on one row at a time, otherwise your results might not make sense.