Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurance of largest duplicate number in a single column ran | New Users to Excel | |||
Counting the largest number of consecutive 1's in a column | New Users to Excel | |||
change the color of a number when it gets too high | Excel Discussion (Misc queries) | |||
How to find the largest change of values in a column | Excel Worksheet Functions | |||
find the largest number in column | Excel Discussion (Misc queries) |