Conditional Formatting Example

From the Conditional Format dialog box, select Account Type in Condition 1: If.


Example of Conditional Formatting Drop-Down List Box

Select Expense, and then click Format Cells button to apply bold formatting to the selected cell. (Leave all other font properties unchanged.)


Example of Comparison Options Drop-Down List Box

Format Cells dialog box with the font set to bold

Click Add Condition 2 buttonto add a second condition. Set the Condition 2: If statement to Current Cell Value. Set the operator value to > (greater than), leave the comparison value set to Value, and set the numeric value to 1000.


Example of Adding a Condition

Click Add Condition 3to add another condition, and then click Format Cells button to set the background color to green when a Cola cell has a value < 1000.


Example of Adding a New Format

Format Cells dialog box with background color set to green

After you establish the conditions, you can select the check box for Allow Parentheses.

In the following scenario:

Condition 1 and Condition 3
or
Condition 2 and Condition 3

If a cell has the label Cola associated with it and the cell value < 1000, the background is set to green. If a Member Name contains Cola and the cell value is < 1000, the background is set to green.