Skip to Content

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



Huu Nguyen

You must be Logged on to comment or reply to a post.