Auto color change

[Guest]

I would like to know if there is a way to have a cell automatically change
colors; here is my scenario. I track dates of several training sessions that
are a requirement for our personnel. Some need to be reaccomplished every 12
months, 15 months and 30 months. When someone's last accomplished date is
within 30 days of expiring, I'd like the "due date" cell to change colors.

 

[Don Guillett]

format>conditional format>formula is>put in your formula>format as desired.

 

[Guest]

What?

format>conditional format>formula is>put in your formula>format as desired.

 

[RagDyeR]

You could use "Conditional Formatting".

It sounds like your due date is already calculated, so you can set the
condition to "activate" 30 days from the system date.

If the due date is in D5, select it and:

<Format> <Conditional Format>
Change "Cell Value Is"
to "Formula Is"
And enter this formula,

=D5-30<TODAY()

Click "Format", and choose what formats you wish, then <OK> <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to know if there is a way to have a cell automatically change
colors; here is my scenario. I track dates of several training sessions
that
are a requirement for our personnel. Some need to be reaccomplished every
12
months, 15 months and 30 months. When someone's last accomplished date is
within 30 days of expiring, I'd like the "due date" cell to change colors.

 

[Guest]

What does () mean after TODAY? I'm putting this formula in and nothing is
happening.

 

[RagDyeR]

If you're talking to me, is D5 a "true" date, and *not* text?

You did set your formats, didn't you?

In a new, empty cell, enter
=TODAY
See what you get.

Then add the parens.

It simply defines a function.

 

[Don Guillett]

If you use =today() in a cell you will get today's date.