Conditional Format based on Date

[ckybam451]

Hello,

I'm attempting to Conditionally format a cell with the following rule:

If today's date is greater than or equal to the date in H3 + 10 (i.e. August 5th + 10 = August 15th), the cell will be formatted

What I currently have and is not working.

=IF(TODAY()>(H3+10))

 

[Joe4]

You don't need to use an IF.
Just create an expression that will return TRUE or FALSE, like this:

[COLOR=#333333]=TODAY()>=(H3+10)[/COLOR]

 

[ckybam451]

Thanks, I was over complicating it

 

[Joe4]

You are welcome.

You *could* use an IF statement, but then you just need to complete all the arguments, i.e.

[COLOR=#333333]=IF(TODAY()>(H3+10),TRUE,FALSE)[/COLOR]

but as you see, it isn't necessary to do so.
Just create an equality or inequality that will evaluate to True or False.