Skip to main content
Question

Corrected formula coding in Color-Coding

  • March 15, 2023
  • 0 replies
  • 110 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

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
------------------------------