From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Conditional formatting based on date proximity

Conditional formatting based on date proximity - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Conditional formatting based on date proximity

“

- [Instructor] In this worksheet we got a list of orders 2 and dates. 3 And in column B, we want those dates to stand out based 4 on what we see in the green panel to the right. 5 If today's date is in there, 6 and at the time of this recording, it's June 19th, 7 you might already have seen that in cell B5, 8 we want it to be red. 9 If it's a date within a week of today on either side, 10 we want it to be yellow. 11 And if it's a date within two weeks, we want it to be green. 12 And we can do this by way of conditional formatting. 13 The formulas, although not terribly difficult, 14 might be a little bit challenging, at least at first. 15 And behind this green panel, I'm simply going to click 16 and move it downward, are the formulas in question. 17 And you don't want to watch me type these, 18 but I want to show you them ahead of time. 19 Here are the three formulas we actually want to use. 20 First one on top here…

Contents