| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I asked for the maximimum value in a colum how can I highlilight
I have asked for the max value to be shown in a colum. How can I ask for the
cell to be auto highlighted. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I asked for the maximimum value in a colum how can I highlilight
Column A example.
Select column A then Conditional FormattingFormaula is: =A1=MAX(A:A) Format to a color you like. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 16:34:01 -0700, Norfolk Bill <Norfolk wrote: I have asked for the max value to be shown in a colum. How can I ask for the cell to be auto highlighted. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I asked for the maximimum value in a colum how can I highlilight
Hi,
In 2007 highlight the range and choose Home, Conditional Formatting, Top/Bottom Rules, Top 10 Item, and change 10 to 1... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Norfolk Bill" wrote: I have asked for the max value to be shown in a colum. How can I ask for the cell to be auto highlighted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Hybrid Mode
