I'm trying to conditionally highlight the greatest value of a column for each set of items in a large table.
For example, I have a table with the following info:
Fruit, Location, Amount
Apples, Fridge, 3
Apples, Counter, 2
Bananas, Fridge, 1
Bananas, Counter 4
I'd like to highlight the number 3 in column "Amount" for the first entry and the number 4 for "Amount" in the fourth entry since those are the two greatest counts of each given "Fruit."
Any help with this is greatly appreciated!![]()
Bookmarks