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!
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.