Auto Highlight largest value in column

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi Again,

How would I format a column to highlight the cell that
has the highest value?

Thanks again.
 
Hi
- select your range (e.g. A1:A10)
- goto format - Conditional Format
- in this dialog enter the formula
=A1=MAX($A$1:$A$10)
- choose your format
 
Frank,

Thanks for the speedy reply, but it doesn't seem to work.

Can I format the entire column instead of a selected
range?

Thanks.
 
I did this Frank, and what I get is every cell that
doesn't have a value in it is highlighted with my
selected format, not the highest value in the column.
 
=A1=MAX($A$1:$A$18)

is exactly (copy and pasted) what I have in the
conditional formating.

I do have formulas in this cell, sorry I forgot to
mention that, will it make a different?
 
Back
Top