Highlight Cells That are Below a Certain Amount

[oliveton]

I'm trying to highlight the background color red for the top worst 20 sales and my expression is not working. 

I have the below entered.

if(BISalesResultSummed <= '-10398.45', RED(), Black())

This results in creating another column with RGB(0,0,0) listed in each cell. 

How do I highlight my background for these 22 or so numbers? 

Thanks 

[Rodj]

Are you using QlikView or Qlik Sense? Your post is tagged as QlikView but as it isn't in the QlikView forum I'm just confirming. Either way, can you provide a screenshot of where you've entered your formula? It sounds as though you are entering it as a measure rather than as a property of the measure that I presume is called BISalesResultSummed.

Cheers,

Rod

[oliveton]

I'm using Qlikview. 

Please see my expression attached below. 

Thanks ! 

[Kushal_Chawda · Accepted solution]

I think you are creating separate expression which is wrong. Click '+' sign of the  actual expression, in back ground color put that color expression.

[oliveton]

I see now, got it. Thanks !