Conditional Coloring parameters help draw attention to a cell’s current value.
When you first open the Visual Parameters window, one condition is visible. You can add others.
If you choose the same color for more than one condition, the color cell is highlighted.
|
Parameter |
Description |
|
Value is… |
Each condition begins with a definition of the condition and a check box for turning the condition off. Click the X to remove the condition. |
|
If cell value is… |
Select a condition, then type a cell value or values. Condition values: equal to, not equal to, between, not between, greater than, less than, available (displayed), and unavailable (not displayed). Default = greater than. |
|
Format Cells |
Select text and background colors by clicking the T and color icons. You can also choose no color. Default: Text = black. Background = yellow. |