Actually bpeltzer sort of gave me a solution, but let me explain further in
case of another way.

Let's say A15 has a date of 10/1/2004 (Oct 1, 2004). I need it to be shaded
when it is within 1 month of 10/1/2005 (Oct 1, 2005). Since it is already
past that date, it still needs to be shaded until a new date is entered when
re-training is done. Since there any number of rows and dates, I need it to
look at each cell in the range and shade it if it is older than 11 months
from today's date.

The kicker (that I have not addressed from the previous solution) is I also
have several cells in a range from A1 - A500 that do not have dates in them
since these folks did not ever get trained on that topic. When I run the
"=TODAY()-$A$1000" condition, blank cells are also shaded. I know how to do
a conditional formula to only run a formula if a cell has a value in it, but
wasn't sure if that could be done with conditional formatting also.

THANKS!

--
Bill Foley
www.pttinc.com
Microsoft PowerPoint MVP
"Bob Phillips" wrote in message
...
Bill,

You should be able to do it without VBA .

When you say periodicity, will you enter a date like 1st Aug 2000, and
need
it coloured in Jul 2001, Jul 2002, Jul 2003, etc., or is it a once-ff?

--

HTH

RP
(remove nothere from the email address if mailing direct)


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