training sheets - date calculation

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

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" <nittany.27e5un_1146928201.599@excelforum-nospam.com> wrote in message
news:nittany.27e5un_1146928201.599@excelforum-nospam.com...
>
> 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.

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" <nittany.28oewb_1149086101.6325@excelforum-nospam.com> wrote in
message news:nittany.28oewb_1149086101.6325@excelforum-nospam.com...
>
> 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
>