Look at conditional formula with a condition of Formula Is and a formula of
=A2<TODAY() and set the colour.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Harvey" wrote in message
...
can anyone tell me please how do i highlight a cell in a spreadsheet with
colour if date overdue