Page 196 - Excel 2013 All-in-One For Dummies

178 Conditional Formatting
2. Click the Conditional Formatting button on the Home tab and then
choose Highlight Cell Rules➪Equal To from the drop-down menu. Excel opens the Equal To dialog box, where you define the formatting
rule when a cell contains 100,000.
3. Type 100,000 in the Format Cells That Are EQUAL TO text box and then select Yellow Fill with Dark Yellow Text from the drop-down list box to the right before you click OK.
Next, you define the rule that applies green fill with dark green font to all values that are greater than 100,000.
4. Click the Conditional Formatting button on the Home tab and then choose Highlight Cell Rules➪Greater Than from the drop-down menu.
Excel opens the Greater Than dialog box, where you define the format- ting rule when a cell contains a value higher than 100,000.
5. Type 100,000 in the Format Cells That Are GREATER THAN text box and then click Green Fill with Dark Green Text in the drop-down list box to the right before you click OK.
Finally, you define the rule that applies red fill with dark red font to all values that are less than 100,000.
6. Click the Conditional Formatting button on the Home tab and then choose Highlight Cell Rules➪Less Than from the drop-down menu
Excel opens the Less Than dialog box, where you define the formatting rule when a cell contains a value below 100,000.
7. Type 100,000 in the Format Cells That Are LESS THAN text box and then leave the default Light Red Fill with Dark Red Text selected in the drop-down list box to the right when you click OK.
As you define the three rules, Excel applies them to the range selected in the worksheet. If the cell range is blank at the time you set up these three rules, all the blank cells in the range are given a red fill. As you enter values into the cells, their text takes on the color assigned to their values: dark red font for values below 100,000, dark yellow for all values of 100,000, and dark green for all values above 100,000. In addition, when the values are equal to 100,000, Excel fills the cell with a light yellow background color and when values are above 100,000, a light green background color.
Finally, here are the steps you’d follow to create a rule that formats all values in a cell range that are below the average value in the range with a custom conditional format that applies bold italic to the font and a bright yellow fill color:
1. Select the range of cells in the worksheet to which this conditional for- matting rule is to be applied.