Non-VBA question for Conditional Formatting

[garyj]

Hello and thanks for any help...

I realize this is normally used for VBA, and I have at one time been more involved in VBA on this forum, but today my question is just excel based. Excel's conditional formatting normally works, but I am struggling to make the third format rule work.

I have a date column, the date for which the next Criminal Record Check is due. It is in a table, column N, "Next Ck Due".
I want 3 conditional formats, so that

1. When the due date is 6 months away or less the date will be bold, green.
2. When the due date is 1 month away or less the date will be bold, dark yellow.
3. When the due date is past the date will be bold, red.

Here is what I did... see image.
The 6 mos away does not work. The other two work fine. Any ideas what I did wrong?

Thanks..
Gary

Screenshot 2023-08-25 212859.jpg

[p45cal]

try:
=DATEDIF(TODAY(),$N1,"m")<=6

[Aussiebear]

garyj , you are more than welcome to post excel queries here.

[garyj]

That works.
Thanks so much, p45cal.
Gary