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