With the date in say E5, select
Format Conditional format then change *Cell value is* to *formula is* and
enter:

=TODAY()E5+60

and then set the required format

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"kris" wrote in message
...
I have seen other posts for this but for some reason the suggestions did
not
work for me. I created a sheet and my E column is "Check Date" ... I
would
like to set it so the date will change to red 60 days after that date.
ie,
check dated 01/04/08, will turn red on/after 03/05/08.
(excel 2003)
Thank you!!