Hi,
Im a newbie and trying to figure out how to do a hopefully a simple task within excel.
I was wondering if there are any templates or if someone could help me make a template for the thing i need.
I have a list of 60 people at work that all have to do 3 seperate tests every 6 months each one has differnt dates for the tests..
and was looking for a drop down list of the people i can select for the month coming up to print out and has the dates tests are due on.. for the 3 seperate tests.. and if possible if the test is coming up withing a month it turns yellow. and if it is over due it turns red..
hope that makes sense..
Hope to hear from you soon..
Many thanks
Robin
Bookmarks