Forum Discussion
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
------------------------------
- RhondaJones2 years agoQrew Cadet
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
------------------------------- MarkShnier__You2 years agoQrew Champion
OK, sorry I didn't originally understand that you wanted to check for three different situation and colour code accordingly.
IF(
[Follow-Up] = "Check on Inspection","#5e9dff",
[Follow-Up] ="Waiting on email response","#aff5f1",
Today() > [Adj. By], "#FF0000")
You have to consider the sequence of the tests above because it will go with the first one that is true.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- RhondaJones2 years agoQrew Cadet
Understood. That worked, thank you. That color page is also very helpful.
------------------------------
Rhonda Jones
------------------------------