How do I highlight a field based on a comparison of another field?

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
I need to highlight (or color) the data in a field if it is different that the value in another field.  Is that possible?  If so, how.  I'm stumped!  
Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
There is no simple "Conditional formatting" like Excel has.  The only way to do this is to do a new sort of mirror field and maker a rich text formula field

https://help.quickbase.com/user-assistance/color_field.html

It's a lot less work simply to colorize the whole row of the report or else put up a warning icon beside the field.

But, your call.
(Edited)
Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb
Thank You!  A warning icon would work, or I suppose even the whole row colored would work as well.  How would I do either of those?  

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
The low tech solution is to enable the checkbox for Row colorization.

IF([Field 1] <> [Field 2], "yellow")

Laura has a great app here for choosing colors by the color code.

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

 for example

IF([Field 1] <> [Field 2], "#7FFFD4") // aqua




Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb
Where do I insert that IF statement?  Both the field types are numeric-currency and not formula fields. 
Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb
Nevermind.  I got it.  Thank You for the help!  This will work!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
On a regular table report setup, at the bottom there is a checkbox to enable row colorization. The formula goes in the box.