Conditional formatting based on User input
Business requirement: Highlight any sales revenues that are below sales target, which is a user input control. In other words, if a user wants to highlight any sales revenues that are below $2,000,000 then he can type in 2,000,000 as an input and the result is similar the one below
Here’s how we can do that.
Step 1: Build a report using eFashion Universe
Step 2: Create “Sales Target” variable
Step 3: Design an Entry Field input control on Sales Target
Step 4: Apply Conditional formatting on Sales Revenues using Sales Target as an input
Now enjoy the result