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

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.

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?  

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

Where do I insert that IF statement?  Both the field types are numeric-currency and not formula fields. 

On a regular table report setup, at the bottom there is a checkbox to enable row colorization. The formula goes in the box.