Specifying the format of conditions

Select Format > Conditional Format or click Conditional Formatting on the Objects toolbar.

You can apply a cell format or a style when a condition is met.

Create a condition. To apply a style, select the condition in the List of conditions and select one of the pre-defined styles, from the list.

To create a format for the condition, select Format and click Edit Entry Format. Specify the format in the Edit Format dialog. The Edit Entry Format button is disabled if a style is selected.

Use format

To select which format is used when multiple conditions are met, select a method from the Use format list.

Select first valid condition to apply the format of the first true condition.

Select merge valid conditions to combine the formats of the conditions that are met.

If no condition is met, the cell format is used.

If you merge valid conditions, we recommend that you use styles instead of cell formats. This is because:

If two formats specify the same property, only one will be applied (which one cannot be predicted).
It is easier in the Edit Styles dialog than in the Edit Format dialog, to see which values have been changed from the default.