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.

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.

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.