Auto color change
 

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.

formatconditional formatformula isput in your formulaformat as desired.

--
Don Guillett
SalesAid Software

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

What?

"Don Guillett" wrote:

formatconditional formatformula isput in your formulaformat as desired.

--
Don Guillett
SalesAid Software

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

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


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

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

"Don Guillett" wrote:

formatconditional formatformula isput in your formulaformat as desired.

--
Don Guillett
SalesAid Software

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

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

Regards,

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


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

"Don Guillett" wrote:

formatconditional formatformula isput in your formulaformat as
desired.

--
Don Guillett
SalesAid Software

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

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

--
Don Guillett
SalesAid Software

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

"Don Guillett" wrote:

formatconditional formatformula isput in your formulaformat as
desired.

--
Don Guillett
SalesAid Software

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