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 trie...
Forum Discussion
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
------------------------------
I am trying to highlight the whole row on the table
------------------------------
Rhonda Jones
------------------------------Try this
IF(Today() > [Adj. By], "#FF0000")
Laura Thacker, made a nice app here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000009&dr=1 with all the hex color codes but you can also use many of the color name works like blue, green, pink etc.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------So like this?
Case([Follow-Up],"Check on Inspection","#5e9dff", "Waiting on email response","#aff5f1")
IF(Today() > [Adj. By], "#FF0000")
It is giving me the "extra characters beyond the end of the formula"
------------------------------
Rhonda Jones
------------------------------
