View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ckane ckane is offline
external usenet poster
 
Posts: 21
Default conditional formatting

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.