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

Chapter 18. Using Excel's Data-Managemen... > Using Conditional Formatting with Li...

Using Conditional Formatting with Lists

Conditional formatting can be a great way to call attention to specific information within a spreadsheet, or plot out timelines. The key when using conditional formats is to use a format to call out specific bits of information; for example, you can use it to call out “not to exceed” information or negative numbers.

The example in Figure 18.1 uses an interactive conditional format; when a state is entered in cell D3, the conditional format highlights the cells in the list that match the entry. When you enter a project name in this cell, the conditional formatting highlights the cells referring to that project within the list. Cell E3 contains a formula that then adds the numbers in column E (the Tons column) for the highlighted list entries. The key is to use the Excel tools in innovative ways to make your everyday tasks easier. By combining conditional formatting with a formula, a single entry in cell D3 yields two results: The specified project entries are highlighted in the list, and the tonnage for that project is totaled in cell E3. You can use up to three conditional formats within a list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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