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

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?

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

Have a look at Conditional Formatting in Help,
Regards,
Alan.
"Bill" wrote in message
...
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?

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

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.




On Tue, 13 Nov 2007 18:14:00 -0800, Bill wrote:

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?

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

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

"Bill" wrote:

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?