Conditional Formatting to highlight date ranges

[SomethngWicked]

Hey guys, I'm trying to write a couple of conditional formatting formulas that will be applied to a varying date range in column L. The general goal is this:

First Formula: Highlights cells if the column date range is 1 to 2 days older than the current date
Second Formula: Highlights cells if the column date range is 3-7 days older than the current date
Third Formula: Highlights cells if the column date range is greater than seven days than the current date:

I think something along the lines of =NOW()-L1<2 should work for the first formula, but it's not. Any help would be greatly appreciated!

 

[Fluff]

How about
=L2<TODAY()-7
=L2<Today()-2
=L2<Today()

 

[SomethngWicked]

How about
=L2<TODAY()-7
=L2<Today()-2
=L2<Today()

Hey Fluff,

I think the -7 works for the greater than seven days range, but I'm not getting anything highlighted for the TODAY()-2. Any other ideas?

 

[Fluff]

Do you have them in that order, when you look at "Manage rules"?

+Fluff.xlsm
	L
1	Dates
2	28/03/2020
3	29/03/2020
4	30/03/2020
5	31/03/2020
6	01/04/2020
7	02/04/2020
8	03/04/2020
9	04/04/2020
10	05/04/2020
11	06/04/2020
12	07/04/2020
13	08/04/2020
14	09/04/2020
15	10/04/2020
16	11/04/2020
17	12/04/2020
18	13/04/2020
19	14/04/2020
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L2:L19	Expression	=L2<TODAY()-7	text	NO
L2:L19	Expression	=L2<TODAY()-2	text	NO
L2:L19	Expression	=L2<TODAY()	text	NO

 

[SomethngWicked]

That works great, it was definitely a problem on my end with the way the formulas were arranged. Thanks so much for your help!

 

[Fluff]

You're welcome & thanks for the feedback