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
 
G

Guest

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

Conditional Format 2
Conditional format question 4
Conditional Formmating Help 2
Conditional Formatting using Small 1
Conditional formatting dates 3
Conditional format a column based on value in a different column 3
Conditional formatting - getting input from another cell 6
Comparison of columns using Conditional Formatting 3

Top