Heather

assuming a header row and that the dates are in column A, then something
like:

Conditional Formatting Formula is: =TODAY()$A2+30

Copied to all the cells you want to turn red

Regards

Trevor


"Heather via OfficeKB.com" <u14448@uwe wrote in message
news:552746cbb541d@uwe...
Hi
I have a spreadsheet with people's certificates (eg. CPR) with the date
the
cerficiate expires. I want to be able to open the spreadsheet at any time
and have anyone whose certificate is one month from expiring, be red (I
want
the whole cell to turn red.) I've tried conditional formatting but can't
seem to get it. Any help would be greately appreciated!!

Thanks:)

Heather

--
Heather