TODAY fucntion in a formula / conditoinal format?

B

bludovico

Okay, here's another easy one. I want a formula that basically says "IF
DATE IN COLUMN D => TODAY, THEN COLOR = RED." I can do the conditional
format, but I'm having trouble figuring out the formula syntax. Any
help?
 
A

Alex Delamain

Is this part of a macro or VBA?

If not you can do it with conditional formatting at a cell level.

If A1 contains the date then use Format, Conditional Formatting,
set condition1 to "formula is" then enter +A1=today() and your choice
of formatting options.
You can then transfer this conditional format to other cells or to the
whole column
 
Top