Change Label Background Color based on Value

  • 8 May 2018
  • 1 reply
  • 20 views

Badge +3

Have an interesting scenario that I'm working through and thought I would post here for input or to post the solution once I find it.

Scenario

In short we are creating an electronic approval processes to replace a paper one regarding requisition requests, requests to purchase stuff. Like most places we have thresholds and you have to do different things depending on the threshold dollar value. I'm designing the form and workflow to walk someone through the policy instead of assuming they know it all. It will tell them what they need to do next and so on. To visually aid this activity I want to highlight the threshold on the form once they provide an estimated amount to spend.

Question

How do I give the appearance of highlighting a label field, I assume by changing its background color, based off the amount they enter in a box on the form, a single line text box. If they enter $3,000 I want to highlight the label box related to the threshold of $2,500 to $10,000.

Any help is greatly appreciated.

Basically each cellish looking part below is a different label box.


1 reply

Badge +3

Should have waited a bit longer. So while working with some other rules to disable the quote entry areas I stumbled on what I needed. Here is what I did to implement.

So rules aren't just for hiding/disabling, there is a whole section below it for formatting. Wasn't sure how that was used till I got brave enough to select one of them. In short I created rules for each of the dollar thresholds and then used the fill color in the formatting section and returned items to no fill once done. Here are a few screen shots.

Little cleanup to do with background color, lines, and spacing, but it works.

Reply