Comparing Dates with todays date
That's the next stage in the Conditional Formatting dialogue after inserting
the formula for the condition.
Have you looked at Excel help for Conditional Formatting?
--
David Biddulph
housinglad wrote:
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.
.
|