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

Chapter 4. Formatting Your Worksheets > Applying Conditional Formatting

Applying Conditional Formatting

With conditional formatting, you can instruct Excel to change the formatting for a cell automatically if the cell's value changes, based on the criteria you establish for change. For example, if the value of a cell in your inventory spreadsheet falls below zero, you can instruct Excel to flag the cell with a heavy red line and shading, and boldfacing the text. The formatting change will alert you to the cell and its contents. This is helpful when you're trying to keep an eye out for changing values. Conditional formatting can help you with error checking your entries and performing exception reporting for analysis. In order for Excel to apply the formatting, however, it must first meet the criteria you establish.

Figure 4.19. Use the Format Painter tool to copy formatting from one cell or range to another.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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