Can I change the color of the largest number in a column?

G

Guest

In an Excel 2007 spreadsheet I have a column of numbers that is incremented
each month. I would like to have the largest number in that column -- which
may change from month to month -- appear in read not black. How do I write a
formula to do that, or how otherwise do I do it?
 
M

Myrna Larson

Assume the numbers are in column A. Use conditional formatting, and in the first box
select Formula Is. Use this formula: =A2=MAX($A$2:$A$10000), and set the formula to font
color red.

$10000 should be large enough that your data won't extend below that row.
 
S

S.Paul

Select the range of cells in that column,go to conditional formatting,select
new rules, click new rule, select the 3rd rule type "format only top or
bottom ranked values" select "top" in the rule description box then enter 1
in the adjacent box then select format and selct whatever color you want to
apply to highest value
 

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

adding largest numbers 2
Determine average of largest 5 numbers in a column. 6
Find values across a row and return a text value from the same column 2
Finding a folder with the largest number. 1
find the largest number in column 4
How can I select the largest number in a list... 1
Formula (or code) return the largest number of duplicates in a list. 16
ranking numbers in a column 7

Top