Comparing Dates with todays date

  • Thread starter Thread starter housinglad
  • Start date Start 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
 
Back
Top