Conditional Formmating Help

S

steven.britton

I have a row of 5 numbers -

I want to highlight the lowest number in the row using conditional
formatting

Help out there?

-Steve
 
B

Bob Umlas

If A1:E1 are selected:
=A1=MIN($A1:$E1)
is the formula to use in the conditional formatting dialog...
Adjust accordingly
Bob Umlas
Excel MVP
 

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 Highlighting duplicates 0
Conditional Formmating 12
Conditional Formatting in XL2007 3
Excel Conditional Formatting 1
conditional format question - I think... 3
Conditional Formatting using Small 1
Highlighting the entire row with conditional formatting 10
Conditional formatting a cell containing "<" 4

Top