Conditional Formatting Using the Bullhorn Reporting Condition Explorer

This article will show you how to apply conditional formatting to your report to highlight exceptional data. Condition Explorer makes it possible to define your criteria and apply that formatting.

Adding the Variables

1. Use this article to Adding, Copying, and Modifying Reports in Bullhorn Reporting (Previously Canvas)
2. On the table, select the three dots to open the Show Properties panel.
3. Select Render Variable, then click More.
   
4. In the Render variable pop-up, click Variable > <New string variable>.
5. Select Conditional Styles, then click More.
   
6. In the Conditional styles pop-up, select the plus icon and choose New Conditional Style.
7. In the New variable pop-up, select Add.
   
8. In the Add pop-up, enter the name for the variable then click OK.
   
9. On the New variable window, click OK.
10. In the Report expression pop-up, click Functions > Constants > double-click string.
11. In the Expression Definition box, between the two ', type in the below expression:
    Copy

    Update [FIELD EXPRESSION] with the appropriate field you’d like to use and ### with the appropriate numerical values

    if([FIELD EXPRESSION]>###) then ('high') else if ([FIELD EXPRESSION]<###) then ('low')

12. Click Validate

13. Fix any errors that come up.

14. Click Ok.
    

15. Select the Report tab, and then click Variables.
    

16. In the Variables box, click the string you created. This will move your variable to the Values tab.

17. Under the Values box, select Add.
    
    

18. In the Add pop-up, type the Value as “high” and select OK. Repeat this and the previous step for "low."

19. In the Show properties pane, Name, type in a name for your variable and press Enter on your keyboard.
    

Applying the Formatting

Now we’ll decide how we want to format our “High” and “Low” values.

Select Back on the Toolbar to go back to the main report page.

Select the data row for the column you’d like to format.

In the Show properties pane, under Conditional, select the Style Variable and then click more.

In the Style Variable pop up, choose the Variable you created and select OK.

Click Conditional State and Select High.

In the Show properties pane, under Color & Background, select .either Background color or Foreground color, then click more.

Choose the color you’d like to signify a high number, and select OK. Repeat the last three steps for “low.”

Save your report to lock in your changes.