Microsoft Office Tutorials and References
In Depth Information
FIGURE 5.17 Conditional Formatting and Option in Excel 2003
FIGURE 5.18 Conditional Formatting
Applying Three Rules
Use the following example: Apply the following conditions to a cell or range
1. Apply a green font color if the value is less than 100.
2. Apply a yellow background if the value is less than 50.
3. Apply a red background if the value is less than 25.
Use Conditional Formatting as you see in Figure 5.18.
Use the data set in the sheet named Review in the chapter
s workbook to format the
area. The data and its chart are shown here.