Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How do I highlight a field based on a comparison of another field?
Casie Masters
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. ...
QuickBaseCoach Dev./Training
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 ...
Casie Masters
10-17-2018 23:58
Thank You! A warning icon would work, or I suppose even the whole row colored would work as well. ...
QuickBaseCoach Dev./Training
10-18-2018 00:02
The low tech solution is to enable the checkbox for Row colorization. IF([Field 1] <> [Field ...
Casie Masters
10-18-2018 00:08
Where do I insert that IF statement? Both the field types are numeric-currency and not formula fie ...
Casie Masters
10-18-2018 00:09
Nevermind. I got it. Thank You for the help! This will work!
QuickBaseCoach Dev./Training
10-18-2018 00:09
On a regular table report setup, at the bottom there is a checkbox to enable row colorization. The formula ...
1.
How do I highlight a field based on a comparison of another field?
1
Like
Casie Masters
Posted 10-17-2018 22:52
Reply
Reply Privately
Options Dropdown
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?
0
Like
QuickBaseCoach Dev./Training
Posted 10-17-2018 23:45
Reply
Reply Privately
Options Dropdown
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?
0
Like
Casie Masters
Posted 10-17-2018 23:58
Reply
Reply Privately
Options Dropdown
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?
0
Like
QuickBaseCoach Dev./Training
Posted 10-18-2018 00:02
Reply
Reply Privately
Options Dropdown
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?
0
Like
Casie Masters
Posted 10-18-2018 00:08
Reply
Reply Privately
Options Dropdown
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?
0
Like
Casie Masters
Posted 10-18-2018 00:09
Reply
Reply Privately
Options Dropdown
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?
0
Like
QuickBaseCoach Dev./Training
Posted 10-18-2018 00:09
Reply
Reply Privately
Options Dropdown
On a regular table report setup, at the bottom there is a checkbox to enable row colorization. The formula goes in the box.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic