2 Replies Latest reply: Jul 15, 2016 5:17 PM by Thirumala Dandamudi RSS

    Conditional Formatting to Highlight Dates older than x Days with a status of y

    Myles Holland

      Hello all,

       

      I would like to use some sort of Conditional Formatting to identify certain rows of data older than 30 days.

       

      I have a Project Created Date field in MM/DD/YYYY, where I want to use conditional formatting to identify Projects that are older than a 30 days, where their status is not A, B, C or D.

       

      The goal of this is to identify the above, but not include for projects that have moved onto a status that this information is no longer important.

       

      Thank you in advance for any assistance.