Forum Discussion

RhondaJones's avatar
RhondaJones
Qrew Cadet
2 years ago

Corrected formula coding in Color-Coding

I currently have this code 

Case([Follow-Up],"Check on Inspection","#7FE2EA", "Waiting on email response","#f69100")

and I wanted to add a code to highlight a record based on a date field. I tried both of these and they are not correct. Can anyone assist me with how this field should be formatted?

If(Today() > [Adj. By], "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", [Record ID#])

Case(
  Today() > [Adj. By], 
  "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", 
  [Record ID#]
)

Thank you!

 



------------------------------
Rhonda Jones
------------------------------

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago

    Are you trying to highlight a whole row with Row colorization, or are you trying to highlight a single field in a report?



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

      I am trying to highlight the whole row on the table



      ------------------------------
      Rhonda Jones
      ------------------------------