Thread: I asked for the maximimum value in a colum how can I highlilight
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote