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 more than two days after the order date.…