in excel conditional formatting find the greatest value in 4rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in excel conditional formatting i want to find the greatest value in a column
and change its colour
 
Hi!

Suppose the numbers are in the range A1:D5

Select the range A1:D5
Goto Format>Conditional Formatting
Formula is: =A1=MAX($A$1:$D$5)
Click the Format button
Select the style(s) you want
OK out

Biff
 

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

Conditional Formatting 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Conditional formatting on a dynamic range - workaround 1
NEED TO CREATE A CONDITIONAL FORMULA 1
Conditional format SUMPRODUCT 3
Help needed 0
Excel conditional formatting with Weeknum 4
Excel Conditional Formatting Removal 7

Back
Top