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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
How do I set focus (and select text) on a text box on a modeless userform? 0
I can create Publisher documents, but I can not open / read them. 0
I have a document with 8 different templates on it. 1
Copy values for every nth cell 7
Help needed: Minimum value based upon either/or criteria 3
How can I install Publisher in 365 Enterprise? 1
formula for arriving net difference 0

Top