How do I make it change colour
 

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

Go to FormatConditional Format.

"raven_guy" wrote:

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

Sorry.... What do I do from there.

Ron

"Pat Flynn" wrote:

Go to FormatConditional Format.

"raven_guy" wrote:

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

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

When oyou select "Conditional Fromatting" a box will appear. You can set
either "Cell value" or formula is. In your case select "cell value" tab to
the drob down list and select equal to or greater than for your condition.
Then select format. This gives you the option of changing the border color,
font color, or background color if a condition is met. You can use up to
three conditions in the method. Just lay with it a bit-its quite simple.
Good Luck
Pat

"raven_guy" wrote:

Sorry.... What do I do from there.

Ron

"Pat Flynn" wrote:

Go to FormatConditional Format.

"raven_guy" wrote:

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