From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Use conditional formatting based on comparison criteria

Use conditional formatting based on comparison criteria

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Use conditional formatting based on comparison criteria

“

- [Voiceover] Excel's conditional formatting feature found on the Home tab gives us lots of opportunities for highlighting cells based on a variety of rules, and we can use data bars, color sets, icon sets, to really give emphasis to certain kinds of data based on the content. And we could use this in a variety of ways, including, even, for example, showing in column H here, whether some of these states have grown more than 5%. In other words, we can use formulas with this. We could also do this over in Column C. We've got a bunch of orders listed by order number in Column A, and order date, shipping date, and we want to know any time a shipping date is more than two days after the order date. Maybe most of our products require some assembly and packaging, so we'd like to highlight everything in Column C, even for future data that we don't have there just yet. So in Column C we're gonna be using conditional formatting, and we want to highlight those cells any time the shipping date is…

Contents