Just check what happens when K3 is the same date as R3.

Pete

On Feb 11, 5:17*pm, "Terry" wrote:
I carried on searching for solution and came up with this one, which I can
modify:
=IF(K3 $R$3, "LATE",IF(K3 < $R$3,""))
Cells are adjusted to suit my new spreadsheet.

I do apologise if any inconvenience guys.

Terry"Terry" wrote in message

...



Office 2003
Win XP Pro.

I have a spreadsheet with A)col. "names" * * and * * * * B)col. "dates
paid"
My desire is to use another column (say C), with function to highlight
"any date after a certain date has passed".
I have tried conditional formatting but cannot get it right!!

Col A * * * * * Col.B * * * * * * * * * * * * * * Col. C
smith * * * * *15/2/08 * * * * * * *if after 18/2/08 then "bad",
otherwise col. B

TIA
Terry- Hide quoted text -

- Show quoted text -