format row of cells to highlight least amount

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

Guest

I need to have the least amount in a row of cells automatically highlight in
a differant color.
 
One way:

Select the row (say, row 1, with cell A1 the active cell). Choose
Format/Conditional Formatting...

CF1: Formula is =A1=MIN(1:1)
Format1: <patterns>/<different color>
 
You must log in or register to reply here.

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

Highlight Highest Amount 2
Excel Highlighting duplicates 0
Highlighting the entire row with conditional formatting 10
Conditional format a column based on value in a different column 3
Excel Typed text appears in wrong cell 0
Excel Highlight active cell with font color? 3
Conditional formating based on blank cell 3
Percentage Increase 13

Back
Top