Conditional Formula to highlight all dates = Today

SherryFox

I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to do this and selected the word "today" it put in today's date. When tomorrow arrives, that will obviously not be helpful. Basically what I want is:

Highlight all dates = TODAY in bright Yellow

Ray Lindstrom

Hi @SherryFox,

As long as your column is a date column you can try the following. Instead of typing in Today with an operator like "is equal to", use the Date "is today" criteria.

Is that what you're trying to accomplish? It seems to have worked for me, and will work tomorrow and everyday thereafter.

All the best,
-Ray

Paul Newcome

You should be able to do this directly in conditional formatting:

Ray Lindstrom

Hi @SherryFox,

As long as your column is a date column you can try the following. Instead of typing in Today with an operator like "is equal to", use the Date "is today" criteria.

Is that what you're trying to accomplish? It seems to have worked for me, and will work tomorrow and everyday thereafter.

All the best,
-Ray