Conditional Formatting Dates

jcb8812

I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's date. 

The context is that these days are our initial contact date. If we go 7 days without contact (changing the date to the current date) I want the cell to be pink, if we go 14 days from the initial date I want it to turn light red, and if we have gone 30 days without contact I want it to turn dark red. 

Shaine Greenwood

Hello,

You'll want to use the "is in the next x days" or "is in the last x days" criteria in your conditional formatting rules.

More on conditional formatting rules can be found in the help center: https://help.smartsheet.com/articles/516359-conditional-formatting