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