- [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,…

Resume Transcript Auto-Scroll

Author

Released

7/17/2017

Excel's conditional formatting feature allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this brief course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Dennis begins with a demonstration of how to format based on cell content or formulas. Next, he shows how to go beyond Excel's default formatting (cell highlighting) by using data bars, icon sets, and color scales. Lastly, Dennis shows how to apply conditional formatting across rows, including how to highlight PivotTable results and incorporate check boxes and data validation pick lists to create dynamic visual displays.

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.