highlight largest number in a row
 

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.

highlight largest number in a row
 

snmcpa wrote:
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

highlight largest number in a row
 

Thanks.

"Pierre" wrote:


snmcpa wrote:
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