highlighting the Largest Number

  • Thread starter Thread starter rowedf
  • Start date Start date
R

rowedf

I have a column of numbers that are summed from other cells. I want t
flag or highlight somehow the largest number in that column, how can
do that?

Thank

rowed
 
Select all numbers, do format>conditional formatting
cell value is equal to =MAX($A$2:$D$50)
click format button and select patterns

replace A2:D50 with your range
 
Back
Top