How to shade a cell within a column if the date is in the next 6 months or less?

[sammytomo]

Hi there,

I am having problem creating a formula that highlights/shades a cell that has date within the next 6 months.

For example todays date is 1 Jan 2023. I have two lease expiries, one on the 1st Apr 23 and the other on the 1st June 23 how do I have those cells highlighted? Both these cells are in Column AK.

I am using it for lease expiries in my database.

 

[Kerryx]

 

[Kerryx]

Book1
	A	B
1	01/01/2023	01/04/2023
2		01/07/2023
3		01/09/2023
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B3	Expression	=DAYS($B1,$A$1)<=90	text	NO
B1:B3	Expression	=DAYS($B1,$A$1)<=183	text	NO
B1:B3	Expression	=DAYS($B1,$A$1)>183	text	NO