Conditional Formatting Example
From the Conditional Format dialog box, select Account Type in Condition 1: If.
![Example of Conditional Formatting Drop-Down List Box Example of Conditional Formatting Drop-Down List Box](img/cf1.jpg)
Select Expense, and then click to apply bold formatting to the selected cell. (Leave all other font properties unchanged.)
![Example of Comparison Options Drop-Down List Box Example of Comparison Options Drop-Down List Box](img/cf2.jpg)
![Format Cells dialog box with the font set to bold Format Cells dialog box with the font set to bold](img/cf6.jpg)
Click to 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 Example of Adding a Condition](img/cf3.jpg)
Click to add another condition, and then click
to set the background color to green when a Cola cell has a value < 1000.
![Example of Adding a New Format Example of Adding a New Format](img/cf4.jpg)
![Format Cells dialog box with background color set to green Format Cells dialog box with background color set to green](img/cf5.jpg)
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.