I am creating a spreadsheet for work and am attempting to add a highlighting rule that applies a yellow highlight to a cell in a specific column (F) IF the date is more than 60 days ago from the current date (updating daily).
I have created a new rule with
=F1<(TODAY()-60)
It is not telling me that the formula is wrong. It creates the rule no problem, but does not change any of the cells it should be changing.
Can anyone help me see what I'm doing wrong???
Thank you in advance.
Bookmarks