Microsoft Office Tutorials and References
In Depth Information
Review Questions
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
of cells.
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.
REVIEW QUESTIONS
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.
 
Search JabSto ::




Custom Search