MAcro Problem (probably easy)

B

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
 
J

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:D,today())>=1

and set the format

Cheers
JulieD
 
Top