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
From the course: Excel 2016: Tips and Tricks
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
Use keystroke shortcuts for frequently needed numeric formats6m 29s
-
Accentuate data with alignment tools6m 2s
-
Add a color background to every 5th row in a range5m 40s
-
Use conditional formatting based on comparison criteria5m 13s
-
Use conditional formatting to highlight formula cells only2m 54s
-
Create custom formats: Dot leaders and more6m 1s
-
Use special formats for times over 24 hours4m 9s
-
Add/remove strikethrough and borders with keystroke shortcuts3m 34s
-
Quickly format phone and SS numbers3m 54s
-
-
-
-
-