Conditional Formatting based on Date

All,

I would like to create a conditional formatting based on a date.

Use case below:

Column A is a date - I would like Column B to turn yellow if it is under 10 days from Column A date, turn orange if past 15 days and turn red if past 15 days.

Is this possible? Would I need to create a formula? Doesn't look like I can base this solely on conditional formatting.

Best Answer

Answers

  • Nicole Hodges
    Nicole Hodges ✭✭✭✭✭✭

    Thank you so much!!!

  • No problem! Glad this worked for you 🙂

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

  • beatea
    beatea ✭✭

    Hello. I have the same question but was not able to apply format based on column A to column B. How do I compare the two dates?

  • Hi @beatea

    What column type is Column A? Could you provide a screen capture of your sheet (but block out sensitive data) and identify what you want the conditional formatting to do?

    Thanks,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!