How do I make a date turn red if past due and start actual is not checked?

Best Answer

  • Kaveri Vipat
    Kaveri Vipat โœญโœญโœญโœญโœญโœญ
    Answer โœ“

    Hi Tameka,ย 

    You can use conditional formatting to make a date turn red. Please you can take reference to the below screenshot.

    MicrosoftTeams-image (70).png

    Please let me know if this works for you!

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful๐Ÿ’ก" or "Awesomeโค๏ธ" and "Vote Upโฌ†๏ธ"

Answers

  • Kaveri Vipat
    Kaveri Vipat โœญโœญโœญโœญโœญโœญ
    Answer โœ“

    Hi Tameka,ย 

    You can use conditional formatting to make a date turn red. Please you can take reference to the below screenshot.

    MicrosoftTeams-image (70).png

    Please let me know if this works for you!

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful๐Ÿ’ก" or "Awesomeโค๏ธ" and "Vote Upโฌ†๏ธ"

  • Tameka
    Tameka โœญโœญ

    Thank you! But what steps do I take to create the rule?

  • Tameka
    Tameka โœญโœญ

    never mind I found it! Thank you