Conditional Formatting Date Formula

Hello.

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:

=NOW()+7

=NOW()

=ISBLANK($A$1:$M$1)=TRUE

The issue is that it won’t format these cells as they are a formula which reflect a date.

By: Shawn

Leave a Reply

Your email address will not be published. Required fields are marked *