Conditional formatting

[Kabook4511]

If need to condition my spreadsheet to highlight cells green if date in cell is less than 8 months from today's date, highlight yellow if date in cell is between 8 and 11 months old and red if date in cell is 12 months or older.

 

[Eric W]

Welcome to the forum!

Try:

Where the individual formulas are:

Book1
	F
1
2
3
4
5	1/1/2020
6	4/1/2020
7	10/1/2020
8	2/10/2021
9	1/1/2022
10
11
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F:F	Expression	=(F1<>"")*(F1<EDATE(TODAY(),-12))	text	NO
F:F	Expression	=(F1<>"")*(F1>EDATE(TODAY(),-8))	text	NO
F:F	Expression	=(F1<>"")*(F1>EDATE(TODAY(),-12))	text	NO

To enter the formulas, select the column, click Conditional Formatting > New Rule > Use a Formula, and enter the formula and select the formatting. Make sure to change the column in the formula to match your selected column. You also need to make sure that the Green formula precedes the Yellow formula.

 

[kanadaaa]

Test.xlsm
	E
5	22/06/2020
6	22/05/2020
7	22/02/2020
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:E7	Cell Value	<TODAY()-330	text	NO
E5:E7	Cell Value	between TODAY()-241 and TODAY()-330	text	NO
E5:E7	Cell Value	between TODAY()-1 and TODAY()-240	text	NO

 

[Kabook4511]

Thank you all! I ended up figuring it out and used following formulas:
Red
=DATEDIF(C4,TODAY(),"y")>=1

Yellow
=DATEDIF(C4,TODAY(),"m")>=9

Green
Cell does not contain blanks

White
If cell is blank