highlight largest number in a row

[Guest]

I am working on a spreadsheet and want the highest number in a row to be
highlighted. Can someone tell me how to format this to work automatically.

 

[Pierre]

I am working on a spreadsheet and want the highest number in a row to be
highlighted. Can someone tell me how to format this to work automatically.

In a cell on your sheet lets say C1 enter =LARGE(A2:A7,1) which looks
for the largest number in the range.
This assumes the range to look for the largest value is A2:A7.

Now use conditional formatting in the range A2:A7, if the value in the
range is equal to the result in C1, format to your liking with borders,
background colors, etc.

Pierre

 

[Guest]

Thanks.

In a cell on your sheet lets say C1 enter =LARGE(A2:A7,1) which looks
for the largest number in the range.
This assumes the range to look for the largest value is A2:A7.

Now use conditional formatting in the range A2:A7, if the value in the
range is equal to the result in C1, format to your liking with borders,
background colors, etc.

Pierre