training sheets - date calculation

N

nittany

I have 200 members with different dates for different classes. Eac
class has to be refreshed in a different amount of months. I have
record of the last times they have taken the class, but would like t
project it out 30, 60 and 90 days - and eventually color code it base
on current, coming due or due.

I have tried different types of conditional formatting, and TODAY() an
NOW() but I can't seem to get it to work.

Any help would be great!

Thanks,
mar
 
F

Fred Smith

We need more information, Mary.

Give us a specific example, as in: I have a date in a3 and I would like to
highlight it in yellow if it's more than 30 days from today.

You'll get a quick response the more specific you can get.
 
N

nittany

Ok, I have a date in a3. Let's say this is recurring training every 12
months. I would like to find a way for the date in a3 to turn red from
30 days before until a new date is entered.

So say you took this training in May 05, you would come due in May 06.
The cell should be green from May 05 until March06, then Yellow in Apr
06 and Red in May 06.

Each column would have a different date, some training is 12 months, 15
months, 24 mos, 36 mos.

The sheet has to compare the date entered to today's date and determine
how much time has passed and then apply a rule. I haven't been able to
get it to work yet.
 
F

Fred Smith

Use Conditional Formatting (under the Format menu).

You can use up to three conditions per cell, which would meet your green,
yellow, red requirement. The red conditional format would be something like:

=TODAY()>DATE(YEAR(A3)+1,MONTH(A3),1)

If you need further help, post back.
 
Top