How do I highlight a field based on a comparison of another field?
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!
Forum Discussion
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
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