Conditional Formats - Help requested

R

Robert A

A1 to A3 are 200,300,250 respectively.

I would like to enter a conditional format something like this: =max(a1:a3)

A2 should respond since it is the maximum in the range, the others should
not. How do I make this work?

Thanks,
Robert


--
___________________________
Robert Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025
Tel: 310-571-1224
Fax: 310-571-1227

(e-mail address removed)
 

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

Using VLOOKUP in an array 6
Help with an array 4
Forumales with defined names 4
Excel crashes 4
Creating data labels in XY charts 2
Combining multi-part attachments in Outlook 03 4
Importing a chart from Excel 0
Exporting a chart into Outlook 3

Top