• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Adding Cell Borders and Shading > Applying Conditional Formatting

Applying Conditional Formatting

Another useful formatting feature that Excel provides is conditional formatting. Conditional formatting allows you to specify that certain results in the worksheet be formatted so that they stand out from the other entries in the worksheet. For example, if you wanted to track all the monthly sales figures that are below a certain amount, you can use conditional formatting to format them in red. Conditional formatting formats only cells that meet a certain condition.

To apply conditional formatting, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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