highlight lowest value in a list

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

Guest

I would like to highlight the lowest bid in a list of prices submitted by
vendors to stand out.
 
One way:

Assuming the list is in A1:D1, select the range, and with A1 the active
cell choose Format/Conditional Formatting...

CF1: Formula is =A1=MIN($A1:$D1)
Format1: <pattern>/<desired color>
 
Let's say vendors names are in A1:A8 and their bids are in B1:B8
Select A1:B8; use Format | Conditional Formatting
Select Formula is and enter =$B1=MIN($B$1:$B$8)
Now click the Format button on the Conditional Formatting dialog; open the
Patterns tab and choose a colour for you highlighting
Suppose B5 has the lowest value, then A5:B5 will be highlighted
best wishes
 

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

How to bold lowest value 2
Highlight lowest price in a row. 6
How to highlight the lowest valued cell in a column in Excel 2003 2
How to find lowest value in row 1
highlighting 4
How to sum 5
Imposing a limit on Min function 19
Find the lowest number? 3

Back
Top