conditional format question - I think...

S

Sandy Mann

Yes you can do that with conditional formatting:

Largest:
=AND($A$2<>"",A2=MAX($A$2:$C$2))

Mid:
=AND(A2<>"",A2=LARGE($A$2:$C$2,2))

Lowest:
=AND(A2<>"",A2=MIN($A$2:$C$2))

And format as required.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
E

Elkar

Just a note: You may want to write the ranges as $A2:$C2 so that the row
number will remain relative.

HTH,
Elkar
 
S

Sandy Mann

And in my first formula
=AND($A$2<>"",
should have been:
=AND(A2<>"",
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Findiing highest and lowest in rows and columns 3
Conditional format question 4
Conditional Formatting question.... 1
Conditional Format 2
Conditional formatting dates 3
Conditional Formating: MAX & MIN 3
Conditional Formatting using Small 1
Conditional Formatting from a group 6

Top