I asked for the maximimum value in a colum how can I highlilight

N

Norfolk Bill

I have asked for the max value to be shown in a colum. How can I ask for the
cell to be auto highlighted.
 
G

Gord Dibben

Column A example.

Select column A then

Conditional Formatting>Formaula 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
 
S

Shane Devenshire

Hi,

In 2007 highlight the range and choose Home, Conditional Formatting,
Top/Bottom Rules, Top 10 Item, and change 10 to 1...
 
Top