Thanks, bpeltzer! I was hoping to figure out exactly one month from that
day, but this works just fine. Close enough for government work! HA!

I appreciate it!

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP
"bpeltzer" wrote in message
...
You should be able to do that with conditional formatting. Set the
condition
to read 'cell value is less than' and the value to compare to is
=TODAY()-$A$1000, with the value in $A$1000 set to the number of days
allowed
between retraining less the number of days advance notice desired. You
could
set it up so that you've got multiple conditions with different periods to
create shades showing greater urgency, but be sure that you test for the
'most urgent' first.

"Bill Foley" wrote:

Hey gang,

I was wondering if anyone had a solution for this EXCEL query:

I have several worksheets in a workbook that has dates of completion of
various training topics. Some of these topics require annual (12
months),
bi-annual (24 month), 6-month, or even 2-month re-training.

What I am trying to accomplish is to automatically shade all cells for
dates
that fall within one month of these periodicities based on the
computer's
clock when a workbook is opened. Unfortunately different columns have
different periodicities so what I was planning on doing was putting that
monthly number in a cell ("12" in A1000, for example for all Column A
values). When the file is opened, if any of the dates in column A are
more
than 11 months from today's date (A1000 minus 1), they are within one
month
of needing to be re-trained and I want the cell shading to be a light
yellow.

Can this be done using Conditional Formatting without VBA or do I need
something to be run based on an AutoOpen macro?

TIA!

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP