Hello everyone,

I have encountered something that don't seem so complicated but I can't figure it out.

I have a table full of Employees, Cities, Sales etc.

I want to format the rows (Names) which have the highest/Lowest Sales considering the cities.
I mean - highlight the best and worst Employees in each city based on their sales.


Thank you!

table.jpg