Forum

Notifications
Clear all

Conditional Formatting By Category

2 Posts
2 Users
0 Reactions
51 Views
(@blackvan)
Posts: 31
Trusted Member
Topic starter
 

I have a simple table with three columns: Category, Source, Quantity - see attached.

I want to apply a conditional format, within each category, to the highest quantity. My formula for identifying the highest quantity would be along the lines of:

=AND(ISNUMBER($C1), $C1>=LARGE(C:C,1))

but I would like to do this within each category. So, to see the result I want, in the attached example I have highlighted in red the highest quantity each of Apples, Bananas and Oranges.

 

Thanks!

 
Posted : 26/08/2025 12:02 pm
Riny van Eekelen
(@riny)
Posts: 1296
Member Moderator
 

@blackvan

I noticed  from posts about a year ago, that you were using Excel2010. The attached solution won't work if that is still the case, but I hope you upgraded to a more modern version in the meantime. Can't think of an easy way to do this in old-Excel, other than creating a pivot table with the Category in the column area and then use the CF rule you mentioned for each column. That would work.

 

 
Posted : 26/08/2025 3:19 pm
Share: