The currently selected column is shown and you can enter or change:
•Visual Feedback to determine how the formatting set previously is to be applied. This may be to the:
o Cell that matches the condition
o entire Row or Column containing a cell that matches the condition
o Sub-total; or Total if the data it contains matches the condition.
•Background sets the background color from the cell if the condition is met so that certain conditions are highlighted.
•Hide Cell’s Contents is checked if the cell’s data is not displayed, even though its format may depend on that content. Thus, for example, a cell may be set to red, amber or green to highlight priority or seriousness without the need to show the value.
•Text Color, Bold or Italic format the text in the cell if the condition is met.
•Rules are listed if they exist and can be amended or deleted by clicking . Click Add Rule to create additional rules and separate successive ones with AND if both need to be met or OR if either has to be met.
For each rule:
o click if the rule is to check data in another column rather than the selected one. If so, choose one from those listed.
o select from the dropdown list an operator that determines how data is to be matched (such as equal, not equal or contained somewhere in the field).
o enter a value to be matched against or click #FN# to select a function that defines particular data values.
On completion, click Apply to set the condition.