Conditional Formatting for Days After Today

[Tap13]

I am trying to setup a conditional formatting formula in Excel 2013 that will trigger as true if the date entered in an applicable cell is after today. I can get it to work as an if statement in a cell (not using conditional formatting) defined as this:

If(E7>TODAY(),"True","False")

I tried using that line in my conditional formatting, however it does not seem to take effect. I'm unclear if it is as simple as a formatting mistake, or if I am trying to use the wrong formula all together. I found several threads discussing the use of DatedIf, but I have not been able to make this work either. I appreciate any help on this.

 

[NeonRedSharpie]

I believe you don't need the "True" and "False". Those are strings, and not boolean. Conditional formatting takes a boolean TRUE and FALSE.

* Note, I suck with conditional formatting

 

[Tap13]

Thanks for the feedback. I tried it without the true, false statements but had no luck as this:

>today()

(note I'm adding this under the gui, under the 'use a formula to determine which cells to format if that matters).

 

[NeonRedSharpie]

Instead of the "formula", why not just add it in under the "Greater than..." section. It should do the same thing.

 

[Tap13]

I got it to work using

=E7>Today()
=E7=Today()
=E7<today()[ code]
=Today()
This covers dates before today, today, and dates after today. The problem I now have is it applies specifically to that cell and I need it to be applicable throughout a range of cells that should adhere to this formatting.</today()[>