Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Conditional Formatting

There may be times when you want to call special attention to certain cells. For example, you may be working with a list of test scores and want to quickly be able to tell which tests exceed a certain score, fall below that score, or both. Excel's conditional formatting feature lets you format cells so that they change their appearance only when they meet conditions you specify.

To continue with our example, with conditional formatting you can instruct any cell with a value greater than, say, 90 (a high test score) to turn blue—but only if it tops 90. Otherwise, the cell will continue to exhibit its original appearance. Thus, conditional formatting is an effective, and pretty easy, way to highlight certain cells scattered among a large mass of data (imagine reviewing 5,000 test scores!).


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint