View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Salgar
 
Posts: n/a
Default How do I get the largest number in a sheet to stand out on it

Awesome! That worked! Thanks a lot. This one was killing me.

"bpeltzer" wrote:

You can do this with conditional formatting. If your columns of names and
numbers are A and B, starting in row 2 then select cell A2 and Format
Conditional Formatting. Use the drop-down to set up the condition: Formula
Is, =$b2=max($b:$b) then click the Format button and select the highlighting
you'd like and click OK a couple of times. Then select your entire table and
hit crtl+y to repeat the previous operation.


"Salgar" wrote:

One column is the individuals names. The next column the number of cuts per
day. How do I get the highest number to be either bold, blue, or stand out.
Or have the name of the person with the hightest number pop up on a different
cell.