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

Format Conditional Format FormulaIs:
=TODAY()-A159
and pick a red font. Adjust for cell address
--
Gary''s Student - gsnu200763


"kris" wrote:

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

Hi,

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

HTH

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

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

"Gary''s Student" wrote:

Format Conditional Format FormulaIs:
=TODAY()-A159
and pick a red font. Adjust for cell address
--
Gary''s Student - gsnu200763


"kris" wrote:

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

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


Replace @mailinator.com with @tiscali.co.uk


"kris" wrote in message
...
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!!

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.]
--
David Biddulph

"kris" wrote in message
...
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!!