I have a sheet containing the following formulas:
=IF(I5<TODAY(),"Delete","In Progress")
This works fine, however when I attempt to apply some conditional formating
to this and ask to display the results of "Delete" in red it does not work.
Could anyone please provide some guidance, I have checked through the help
and previous posts but still can't make it work. Even when I input the
formula and select OK, the next time I hover over the cell the formula does
not display in the formula bar
Thanks
Bookmarks