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?
|