Cell change colour

[That's Confidential]

In a cell, I will have a specific date, ie 28-May-2004. Now, if that date
exceeds that days date, then I would like the cell to change colour. So, for
example, if it is the 27th May, and in cell D1, the date is 26th May, I
would like the cell to change colour.

Any advice?

Thanks in advance

 

[Bob Phillips]

Use conditional formatting.

Assuming the date is in A1, select that cells.
Goto Format>Conditional Formatting
Change Condition1 to Formula Is
Add this formula
=A1>$D$1
Click Format and select a pattern colour
Exit out


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

Take a look at Conditional Formatting in XL Help.

CF1: Formula Is =A1<TODAY()

 

[That's Confidential]

Fantastic people! Thanks once again!

Take a look at Conditional Formatting in XL Help.

CF1: Formula Is =A1<TODAY()