The Cell Highlight feature allows you to format the value in a cell, based on a condition.
To apply cell value formatting, hover over the required field and choose Cell Format from the Formatting menu:
In the Cell Format window, you can:
- Set and modifiy condition expressions
- Set and change value colors and formats (by clicking on the colored box on the left of the expression)
- Add and remove conditions
|
A condition will be invoked if the expression it holds evaluates to a true statement. While editing a condition’s expression, click Ctrl-Space for a complete list of functions and measures that are available for use.
|
See Also