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
- When the due date is 6 months away or less the date will be bold, green.
- When the due date is 1 month away or less the date will be bold, dark yellow.
- 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