C
ckane
I have created a spreadsheet of various dates of when my employees annual
trainings are due. I would like the cell color to change based on how many
days to their training is due. If the renewal date is more than 60 days away
I would like the cell one color, if the renewal date is 60 days to the date
it is due, the cell would be a different color if the renewal date is past
due it would be a third color. The cells are in m/dd/yy format.
Thank you.
trainings are due. I would like the cell color to change based on how many
days to their training is due. If the renewal date is more than 60 days away
I would like the cell one color, if the renewal date is 60 days to the date
it is due, the cell would be a different color if the renewal date is past
due it would be a third color. The cells are in m/dd/yy format.
Thank you.