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.
 
Hi
you could also select the entire column A. Then change
$A$1:$A$10
to
$A:$A
 
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.
 
Hi
what formula have you entered exactly in the conditional format dialog
 
=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?
 
Hi
and you have selected cells A1:A18 before entering this formula?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
error in highlighting duplicate values in excel 1
format cells in one column based on value in another column 3
Changing the format of data in a cell 3
Highlight Highest Amount 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
how to highlight cells ? 3
Return Column Heading based on value in row 2

Back
Top