Date, change font color if past

[betha]

I have a cell that calculates 30 days from the starting
date, and another cell that calculates 60 mos from the
starting date. Once these dates pass, I want the color
to change to say, green. Is there a formula for this?

 

[Govind]

Hi,

choose those cells, Go to Format -> Conditional formatting.
Specify the condition that if the values are more than your specified
limit and then click on "Format" in the conditional formatting window
and choose the format required.

Regards

Govind.

 

[Frank Kabel]

Hi
have a look at 'Format - conditional format' for this. See:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

 

[Frank Kabel]

Hi
put
TODAY()
in this box

 

[betha]

I'm still doing something wrong -- all the cells change to red, not just the
past dates
Thank you for trying to help me.

Beth

 

[Frank Kabel]

Hi
try the following
- assumption: you do this for cells A1:A10
- select cells A1:A10
- goto the conditional format dialog
- choose 'Formula' and enter the following formula:
=A1<TODAY()
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"(e-mail address removed)" <[email protected]@discussions.microsoft.com>
schrieb im Newsbeitrag