highlight largest number in a row

S

snmcpa

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

Pierre

snmcpa said:
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.
Click to expand...

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
 
S

snmcpa

Thanks.

Pierre said:
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
Click to expand...
 
Top