Learn how you can use Excel functions and formulas to define which cells are formatted—by day of the week, by comparison with another cell, and more.
- [Instructor] Although conditional formatting…has a lot of built-in capability…by way of Highlighting Cell Rules, lots of options there,…as well as under Top/Bottom Rules.…But sometimes what you want to highlight…isn't available from those choices.…Let's imagine that in this worksheet here…where we've got column D for Quota, column E for Sales,…we simply want to highlight those cells in column E…that are greater that the Quota entries over in column D.…So, for example, this one is greater than that,…this one isn't, this one is, and so on.…
We simply want these to stand out…by applying a formatting tool.…We'll select column E.…Nothing we see here really jumps out at us…so we go to New Rule…and there are quite a few options here.…The one we're going to be using is…Use a formula to determine which cells to format.…Now when I selected column E, and remember,…many times in Excel…when you're using conditional formatting,…you will be selecting a whole column.…It is particularly helpful because…when lists like this grow or shrink,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows