I have a training spreadsheet for work. I want to, if possible, make this easier to track.
A1 on down are names of employees
B is grade
C- M are the training types
Now I have it set up under the training name ther date and I have all who are current on this training green. Anyone who is due training withing 6 months its yellow. Any training that is a year, or over due/not found are red.
What I would ultimately like to do is to have these color code automatically, if possible, instead of me having to look at every training type and date.
Is there any way to set up a formula using "Today's Date" and having it color code like the above said?
Hopefully its not confusing, if so, I'll screen shot it and show an example of what I have now.
Thanks in advance,
Jim
Bookmarks