Conditional Formmating Help

  • Thread starter Thread starter steven.britton
  • Start date Start date
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
 
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

Conditional Formmating 12
Conditional Formatting in XL2007 3
conditional format question - I think... 3
Conditional Formatting using Small 1
Excel Highlighting duplicates 0
Excel Conditional Formatting 1
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
conditional formatting - repeat formula 7

Back
Top