Comparing Dates with todays date
Declare cell C2 with Conditional Formating - Red Background - as per a
formula such as:
=B2<TODAY()
Micky
"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.
|