Use formatconditional formatting, then formula is and

=A2<=DAY()

click format button and select red pattern or fonts and click OK twice

where A2 is the cell with the date you want to check if it is overdue
if it is 30 days from the date in A2 you can use

=A2+30<=TODAY()


--


Regards,


Peo Sjoblom




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