Corrected formula coding in Color-Coding

Question

I currently have this code&nbsp;
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() &gt; [Adj. By], "&lt;span style='background-color: #FF0000;'&gt;" &amp; [Record ID#] &amp; "&lt;/span&gt;", [Record ID#])
Case(&nbsp; Today() &gt; [Adj. By],&nbsp;&nbsp; "&lt;span style='background-color: #FF0000;'&gt;" &amp; [Record ID#] &amp; "&lt;/span&gt;",&nbsp;&nbsp; [Record ID#])
Thank you!

&nbsp;
------------------------------Rhonda Jones------------------------------

markshnier__you · Answer

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)
[email protected]
------------------------------

rhondajones · Answer

I am trying to highlight the whole row on the table------------------------------Rhonda Jones------------------------------

markshnier__you · Answer

Try this
IF(Today() &gt; [Adj. By],&nbsp; "#FF0000")

Laura Thacker, made a nice app here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&amp;qid=-1000009&amp;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------------------------------

rhondajones · Answer

So like this?
Case([Follow-Up],"Check on Inspection","#5e9dff", "Waiting on email response","#aff5f1")&nbsp;
IF(Today() &gt; [Adj. By], &nbsp;"#FF0000")
It is giving me the "extra characters beyond the end of the formula"------------------------------Rhonda Jones------------------------------

markshnier__you · Answer

OK, sorry I didn't originally understand that you wanted to check for three different situation and colour code accordingly.&nbsp;&nbsp;

IF(
[Follow-Up] = "Check on Inspection","#5e9dff",&nbsp;
[Follow-Up] ="Waiting on email response","#aff5f1",&nbsp;
Today() &gt; [Adj. By], &nbsp;"#FF0000")

You have to consider the sequence of the tests above because it will go with the first one that is true.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Corrected formula coding in Color-Coding

6 Replies

Related Content

Color Code Date Field based on Formula

Color coding formula

Color Coding based on field value

QrewTip: Formula Logic Order

Color-coding a field returns field name