I have a training matrix which has the names of the trainees for the columns.
The rows are used for the subjects.
Some of the training competencies are due for refreshers annually, while some are due for refreshers 3 yearly.
The entries in the colums for each participant against the competencies are recorded on the day of the training.
I want to set up "Conditionally Formatting" as an indicator on who is due for refresher training (30 days - yellow) and who have expired (red).
Ideally, I do not want to set additonal rows or colums for expiry dates, I want to only keep the dates of issue.
Excel 2003
Last edited by short fat bald; 09-20-2011 at 11:50 PM.
One conditional formatting formula that would test if today's date is within 30 days of the 1 year anniversary of the date listed in A1 would be:
=TODAY()>=A1+335
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks