Hi all,
I am attempting to make a sheet that tracks our five and ten year awards plus a ten year longevity. Currently I have each employee's hire date in the H column, the five year award in the J column, a ten year award in the K column, and the ten year longevity. I know there are two columns that will trip at the same time but i want to check them off once the employee recieves the award. the other part of this is I would like the cells to turn yellow when they are within a year of the milestone and red if it is past the milestone (five or ten years from hire). Thank you for your help. Matt
Bookmarks