highlight lowest value in a list
 

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

highlight lowest value in a list
 

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

In article ,
MRB wrote:

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

highlight lowest value in a list
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MRB" wrote in message
...
I would like to highlight the lowest bid in a list of prices submitted by
vendors to stand out.