In a Project report, can I highlight in red the date of the Planned Start Date if it is late AND the project is not Current? | Community
Skip to main content
J
JenniferGa1
Level 2
November 20, 2020
Solved

In a Project report, can I highlight in red the date of the Planned Start Date if it is late AND the project is not Current?

  • November 20, 2020
  • 2 replies
  • 652 views

I currently have conditional formatting that highlights the Planned Start Date if it's late, but we don't want it highlighted once the project starts. The idea is to alert our clients that they have not given us what we need to start the project by our agreed upon date. I attached a screenshot to help.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed_AtAppStore

    Hi Jennifer and Samantha,

    Conditional formatting rules are evaluated top to bottom, applying the rule that is true, so i suggest you:

    • first check for the Project Status = Current and set Planned Start Date background to white (effectively “ignoring” it), then
    • second (ie “otherwise”) check if the Planned Start Date is less than $$NOW then set it to red (ie “take action”)

    Regards,

    Doug

    2 replies

    SamanthaIsin
    SamanthaIsin
    Level 7
    November 20, 2020

    Would also like an answer on this for the use of applying a combination of automation rules to columns!

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    November 21, 2020

    Hi Jennifer and Samantha,

    Conditional formatting rules are evaluated top to bottom, applying the rule that is true, so i suggest you:

    • first check for the Project Status = Current and set Planned Start Date background to white (effectively “ignoring” it), then
    • second (ie “otherwise”) check if the Planned Start Date is less than $$NOW then set it to red (ie “take action”)

    Regards,

    Doug

      J
      JenniferGa1Author
      Level 2
      November 23, 2020

      Thanks Doug! I really appreciate your help!

      Terms & ConditionsAccessibility statement

      Loading footer...