MAcro Problem (probably easy)

[bludovico]

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

 

[JulieD]

Hi

if the date you're looking at is in a particular cell (ie D2) use
in conditional formatting
Formula is
=D2=today()

if it can be anywhere in column D use
Formula is
=COUNTIF(D,today())>=1

and set the format

Cheers
JulieD

 

[Dean]

=TODAY()