I would like to conditional format a series of cells using NOW function or similar. The issue I am having is that the cells in question aren’t dates that are entered manually. They are dates that reference another cell e.g. =M13+30.
Is there a way to get these dates that are a formula to be conditionally formatted? I have no issues doing so for dates that are manually entered.
Ideally, I just want to use:
The issue is that it won’t format these cells as they are a formula which reflect a date.