Forum Discussion

NicholeStebane's avatar
NicholeStebane
Qrew Member
2 years ago

Formula for color coding more than one field

I want to color code two fields within the same table to highlight when they are past due. 

Is there a way to add another due date field to this formula? 
If ([Medical Record/Pharmacy Review-Due Date] < Today(), "red", "")

Thank you!! 



------------------------------
Nichole Stebane
------------------------------
    • NicholeStebane's avatar
      NicholeStebane
      Qrew Member
      2 years ago

      Thank you Mark! Can they both be red or do they have to be different colors?



      ------------------------------
      Nichole Stebane
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago

        They can be the same color or not, it's up to you.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
    • ReneeWilliams2's avatar
      ReneeWilliams2
      Qrew Member
      2 years ago

      Not to complicate this any further, but how could a formula like this be adjusted to not include weekends?



      ------------------------------
      Renee Williams
      ------------------------------