conditional format - Max

  • Thread starter Thread starter tony wong
  • Start date Start date
T

tony wong

What is the formula to apply color to the maximum value? thank you in
advance for your assistance.
 
Hi

If your range is A1:A10, select the range (starting at A1), and use 'Formula
is' with
=A1=MAX($A$1:$A$10)
 
You must log in or register to reply here.

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

Excel VBA 1
Conditional Format? 4
Conditonal formatting problem! 1
Conditional Formatting option not available 6
Excel 2002: Conditional format multiband colors 3
Conditional format for unique values 5
Conditional Format 2
conditional formatting 3

Back
Top