Discussions

Expand all | Collapse all

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

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

    Posted 10-17-2018 22:52
    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!  


  • 2.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-17-2018 23:45
    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.


  • 3.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-17-2018 23:58
    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?  



  • 4.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-18-2018 00:02
    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






  • 5.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-18-2018 00:08
    Where do I insert that IF statement?  Both the field types are numeric-currency and not formula fields. 


  • 6.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-18-2018 00:09
    Nevermind.  I got it.  Thank You for the help!  This will work!


  • 7.  RE: How do I highlight a field based on a comparison of another field?

    Posted 10-18-2018 00:09
    On a regular table report setup, at the bottom there is a checkbox to enable row colorization. The formula goes in the box.