Microsoft Office Professional 2010 Step by Step eBook

4. On the Home tab, in the Styles group, click Conditional Formatting. On the
   menu, point to Data Bars, and then, in the Solid Fill group, click the orange data
   bar format.
   Excel formats the selected range.


5. Select cells I4:I12.


6. On the Home tab, in the Styles group, click Conditional Formatting. On the
   menu, point to Icon Sets, and then in the left column of the list of formats, click
   the three traffic lights with black borders.
   Excel formats the selected cells.

Three types of conditional formatting applied to the same data range.

7. With the range I4:I12 still selected, on the Home tab, in the Styles group, click
   Conditional Formatting, and then click Manage Rules.
   The Conditional Formatting Rules Manager opens.


8. Click the Icon Set rule, and then click Edit Rule.

The Edit Formatting Rule dialog box opens.

Changing the Appearance of Data Based on Its Value 337