Conditional Formatting and Dates

Danielle Mor
Danielle Mor ✭✭
edited 10/11/23 in Smartsheet Basics

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.

Best Answer

Answers