How to use visual cues for top 10 and worst 10

[#1]

Hi All,

I would like to use visual cues for top 10 and worst 10 in my list. I mean I want to use different background & font colour for first 10 and worst 10.

Any suggestions? My list is as per attached notepad file.

Best,

Piroglu1907

[Anonymous · Accepted solution]

Hi,

     Hope the attached and qv and excel files will be helpful for your requirement

Regards

Ashok

[#3]

Hi Ashok,

Really appreciated your help - thank you very much. I was not aware of =max([Male %],10) logic

Best,

Piroglu1907