Highlight high value row

[rehanemis]

Hi,

I would like to highlight the entire row based on the high value of an item:

Here is sample data.

Item name	Value
A	5
A	4
B	8
B	2
B	0
C	9
D	12
D	12
D	11
D	2
D	0

<tbody>
</tbody>

Data is sorted by item and I would like to highlight the entire row based on the high value for each item.

any solution?

 

[majidsiddique]

goto conditional formatting and new rule.
apply this:
=$b2=max($b$1:$b$11)
choose color formatting.

 

[Fluff]

Maybe
select A2:B12 & use this formula
=$B2=MAX(IF($A2=$A$2:$A$12,$B$2:$B$12))

 

[rehanemis]

Maybe
select A2:B12 & use this formula
=$B2=MAX(IF($A2=$A$2:$A$12,$B$2:$B$12))

Great!! worked well.

Can you please also provide bit details how it worked so that I can make amendments or new formula based on this formula logic.

Thanks again!!

 

[BGY23]

Assuming your data is in A4:B14 Highlight the range and use this formula in the conditional formating box. Select a format on the fill tab. If one letter has the same max it will highlight all instances.

=$B4=MAX(IF($A$4:$A$14=$A4,$B$4:$B$14))

 

[Fluff]

Glad to help & thanks for the feedback.
Have a look here for some info https://exceljet.net/formula/maximum-value-if