change color after 60 days

[kris]

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!!

 

[Gary''s Student]

Format > Conditional Format > FormulaIs:
=TODAY()-A1>59
and pick a red font. Adjust for cell address

 

[Carim]

Hi,

Use Format conditional formatting
Formula Is
=E1+60<TODAY()
Pattern
Red ...

HTH

 

[Dave O]

This is a job for conditional formatting. In the cell you want to
change colors, click >Format >Conditional Formatting and a box will
open. Change the dropdown from "Cell Value Is" to "Formula is" and
enter this formula in the box:
=F4-E4>=60
.... where F4 is the date cell and E4 is the check date: you may need
to change the references, of course. Then select the type of
formatting you want to apply when that condition occurs. You can
change the color of the background or change the color of the font,
for instance.

Dave O
Eschew obfuscation

 

[kris]

Thank you!!! Thank you!!! Thank you!!! Thank you!!!

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[David Biddulph]

What suggestions did you try? What was your formula? What result did you
get for what input?

"did not work" is not enough information for people to be able to tell what
you did wrong.

[Not just getting at you, but trying to help you and other users to get
value out of the group.]