Search code examples
google-sheets

Google Sheets Conditional Formatting using AND

I am trying to conditionally format the top 10 scores in a list and the following formula works perfectly:

=$G2>=LARGE($G$2:$G,10)

However, I have two different school classes in my list of data and I would like the top 10 highlighted from each class. I have tried using AND in the formula but I can't quite get the formatting right.

Please help

Formatting Test

Solution

  • 2 conditional formatting rules added to your test sheet Column_H

    Apply to range: H2:H

    =let(Σ,"Y82324_CommStuds",and($C2=Σ,$H2>=large(index(if($C:$C=Σ,$H:$H)),10)))