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

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

Any help would be great!

Thanks,
mary


--
nittany
------------------------------------------------------------------------
nittany's Profile: http://www.excelforum.com/member.php...o&userid=34190
View this thread: http://www.excelforum.com/showthread...hreadid=539532

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.

--
Regards,
Fred


"nittany" wrote in message
...

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

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

Any help would be great!

Thanks,
mary


--
nittany
------------------------------------------------------------------------
nittany's Profile:
http://www.excelforum.com/member.php...o&userid=34190
View this thread: http://www.excelforum.com/showthread...hreadid=539532

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.


--
nittany
------------------------------------------------------------------------
nittany's Profile: http://www.excelforum.com/member.php...o&userid=34190
View this thread: http://www.excelforum.com/showthread...hreadid=539532

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.

--
Regards,
Fred


"nittany" wrote in
message ...

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.


--
nittany
------------------------------------------------------------------------
nittany's Profile:
http://www.excelforum.com/member.php...o&userid=34190
View this thread: http://www.excelforum.com/showthread...hreadid=539532