Select A2, then:

<Format <Conditional Format,

Click
"Formula Is",
Then enter this:

=A2A1+4

Click on "Format", and choose what you wish,
Then <OK <OK
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"raven_guy" wrote in message
...
I am tracking dates in excel... basically as follows... Start date to
completed date... I am looking into how to make a cell change colour after a
certain amount have days have passed?

example: (a1= June 1st 2005 a2= completed date )after 5 days from start
date.. change the completed date cell red.

Thanks
Ron