Conditional Formatting

[luisitocarrion1900]

Hello everyone,

Am looking for a condition Formatting that will highlight a cell blue when the date in the cell is within 6 month, yellow when is within 3 months and red 1 month

 

[DJFANDANGO]

How about...

PRO VDR, 2020 10 06.xlsx
	A	B
1	Expiry Within 6 Months
2	Expiry Within 3 Months
3	Expiry Within 1 Months
4
5		Expiry date
6		11/04/2021
7		22/02/2021
8		24/11/2020
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:B8	Expression	=AND(B6<>"",B6>TODAY()+180)	text	YES
B6:B8	Expression	=AND(B6<>"",B6>TODAY()+90)	text	YES
B6:B8	Expression	=AND(B6<>"",B6>TODAY()+30)	text	YES