Good afternoon
I am trying to conditional format the Due date column (AH) based on the below:
1) Highlight yellow 1 month before due date
2) Highlight red once due date has passed and not actioned
My colleague is currently marking these manually which is not time effective.
I've tried the below but for some reason struggling to get them to work
=(TODAY()-AH6)<=28
=TODAY()>AH6
KR
J
Bookmarks