• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Conditional Formatting

Excel supports conditional formatting, whereby you apply a format based on data values and not based on data type or position on the worksheet. Suppose, for example, you are the manager of a company and need to be alerted when sales fall below a fixed level of $500,000. You can set a conditional format on your sales report worksheets to boldface and color the sales values red if any of them fall below 500,000.

Figure 9.9 shows the Conditional Formatting dialog box that appears when you select Format, Conditional Formatting. The Conditional Formatting dialog box uses these parameters:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint