Change date color beyond certain time period

A Goodman

Hello!

This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed.

For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like it to change to orange. Over 90 days, I would like it to change to red. I would also like to do this without adding another column if possible.

Does anyone know if this doable? I've had no luck searching around the forms and feel like I'm missing something obvious. The attached image shows my current column on the left, and how I would like it to look on the right.

Thanks!

A Goodman

Was able to solve from this thread:

Conditional Formatting based on Date — Smartsheet Community

Have to cheat the last rule but it works just fine.

Naeem Ejaz

Yes, this is absolutely doable in Smartsheet using Conditional Formatting, and you can achieve this without adding any helper columns. Here's a step-by-step guide to set it up so that the date cell changes color based on how many days ago it occurred:

1. Open your sheet.
2. Go to “Conditional Formatting” (from the toolbar or dropdown under "Format").
3. Click “+ New Rule.”

🔸 Rule 1: Over 90 Days → Red

• When: [Your Date Column]
• Condition: is in the past AND
  =TODAY(-90) (see below)
• Custom Formula:
  Choose "Date is in the past"
  Then use "More than" → 90 days

✔ Format: Red Fill

🔸 Rule 2: Over 60 Days → Orange

• Same setup, but:
• Condition: "More than 60 days"

✔ Format: Orange Fill

🔸 Rule 3: Over 30 Days → Yellow

• Condition: "More than 30 days"

✔ Format: Yellow Fill

🔁 Important Rule Order

Smartsheet applies rules from top to bottom, so make sure you arrange them like this:

1. Red (90+ days)
2. Orange (60+ days)
3. Yellow (30+ days)

🔄 If Yellow is on top, it will override Red/Orange unless you re-order.

A Goodman

Was able to solve from this thread:

Conditional Formatting based on Date — Smartsheet Community

Have to cheat the last rule but it works just fine.