Auto color change

A

Addisonbc

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.
 
R

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.
 
A

addisonbc

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

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