Date, change font color if past

  • Thread starter Thread starter betha
  • Start date Start date
B

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?
 
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.
 
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
 
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
 
Back
Top