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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Item name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

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