Comparing Dates with todays date

H

housinglad

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.
 
×

מיכ×ל (מיקי) ×בידן

Declare cell C2 with Conditional Formating - Red Background - as per a
formula such as:
=B2<TODAY()
Micky
 
H

housinglad

Thanks for the formula, but what would be the code to make the cell fo red??
 
D

David Biddulph

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?
 
Top