Page History
...
Option | Description |
---|---|
Description | The description is printed out so a user understands what logic you have used for the formatting. Because of the advanced logic that can be applied you should provide a meaningful description of what you intend to apply. |
Display Style | You can choose how you want the format to be displayed. For example highlight the Cell or insert an icon. |
Colour | If you have chosen a cell style you can select the colour you wish to apply for this rule. |
Format | If you have selected 'Icon' display style you will be able to select from the same icons available to basic rules (see previous table). |
Logic | Enter the logic of your rule. You can select a column the operand and the value. By clicking add you can add additional rules with bracketing etc.
|
Conditional Format Data Validation
...