From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Apply two conditional formatting rules

Apply two conditional formatting rules - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Apply two conditional formatting rules

“

- [Instructor] We've got a little shop, maybe a barber shop or tattoo parlor. Maybe we give life advice, but we want to look at the data, from the 15th of January, down to the 7th of February. We've kind of gotten started here, but there's a problem in the walk-ins column. Up top you see, this should be yellow for values, less than or equal to five, and red for values less than 10. Check out the 22nd of January. It's red, okay, it is less than 10, but it is less than or equal to five, and should be yellow. There are conditional formatting rules here and please get those corrected. The next thing in that totals column, we need a tally, that's walk, plus reservations, minus no shows. Get a tally for that entire column and then apply to conditional formatting. You get to choose how they look, all right. We want to highlight values less than 15, and values less than 10. All right, jump on that, come back and I will show you…

Contents