Skip to main content
Question

Color coding a field based on anything or nothing data

  • March 26, 2018
  • 0 replies
  • 46 views

I am working on some color coding and I can not figure out the formula needed to color a row based on if a field contains anything...can you help me with this? Do I still use Case or do I use If? Example: I have a field labeled Payroll Notes, I want the field highlighted if there are any notes in the field regardless of what they are and not highlighted if the field is blank.
This topic has been closed for replies.

The row colorization formula would be 

IF(Trim([Payroll Notes])<>"", "pink")

or else you can use hex codes

IF(Trim([Payroll Notes])<>"", "#F9A7B0")

Here is an app from another QSP Laura Thacker to see the effect of lots of hex color codes.

https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1

  • Author
  • Registered
  • March 26, 2018
Awesome!!! Thank you soooo Much!!!