How to highlight rows on a table object by column value?

[KellyHobson]

Hey there,

With example dataset, sales_data_sample.csv, I would like to highlight records where QUANTITYORDERED is greater than 50. 

I've played around with the rank function within Style- > Background color -> by expression

=if(rank(QUANTITYORDERED)>50, yellow())

But still cant get it quite working. I want the records to be highlighted even before clicking into any of the data points. 

Any tips are appreciated!

Thank you,

Kelly 

[Chanty4u]

Try this

=if(QUANTITYORDERED > 50, 'yellow', 'white')

[KellyHobson]

Hey @Chanty4u ,

Thanks for the reply. 

Is it possible

1. to pre-highlight the values before having to click into a value

2. only highlight the records above 50?

example this highlights the whole table:

Thanks,

Kelly