TODAY fucntion in a formula / conditoinal format?

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?


--
bludovico
------------------------------------------------------------------------
bludovico's Profile: http://www.excelforum.com/member.php...o&userid=14805
View this thread: http://www.excelforum.com/showthread...hreadid=265059

=$D1=TODAY()

HTH
Jason
Atlanta, GA

-----Original Message-----

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?


--
bludovico
---------------------------------------------------------
---------------
bludovico's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=14805
View this thread:
http://www.excelforum.com/showthread...hreadid=265059

.

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


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=265059