Hi
Check this link, it will explain you how.
http://www.xldynamic.com/source/xld.CF.html
HTH
John
"housinglad" wrote in message
...
Thanks for the formula, but what would be the code to make the cell fo red??

"David Biddulph" wrote:

Conditional Formatting/ Formula Is/ =B2<TODAY()
--
David Biddulph

housinglad wrote:
Hi

I wonder if anyone could help me.

I am trying to look at the date entered in a cell e.g. (in cell B2
05/02/2010). I want excel to look at the date in B2 and if the date
as passed then for cell C2 to turn red.

Can anyone help?

Hope this makes sense.


.