Conditional Formatting and Dates
1) I would like to have a conditional formatting rule for dates.
I keep track of documents that expire annually for each member of my team. I want to input into a cell the date that the document will expire. When the document will expire in 60 days, I want that cell to turn yellow. When it will expire in 30 days, I want that cell to turn orange. When that cell is expired, I want it to turn red.
2) I would also like to know how to set up my sheet so that if I add a new column (when a new person joins my team I will need to make a new column for them), it will copy the formatting done in the previous column automatically.