Highlighting Highest value in a row

[Rick M]

I have a pricing sheet that I have vendor pricing in. How can I highlight the lowest cost in a row?
a1=15.12
b1=12.43
c1=13.50

I want to highlight (in some way)text color or cell background color cell b1
Thanks

[Russell Hauf]

On 2002-02-22 13:11, Rick M wrote:
I have a pricing sheet that I have vendor pricing in. How can I highlight the lowest cost in a row?
a1=15.12
b1=12.43
c1=13.50

I want to highlight (in some way)text color or cell background color cell b1
Thanks

Select your data (A1:C1 in your example), then go to Format-Conditional Formatting. Under Condition 1, change Cell Value is to Formula is, and type in the following formula (taking note of the absolute references - dollar signs):

=A1=MIN($A$1:$C$1)

Then click the Format button, and go to the Patterns tab and format as you like.

Hope this helps,

Russell

[JohnG]

This may do you
Sub LowRange()
Dim LastRow As Integer
Dim FLoop As Integer
Dim LowAddress As String

LastRow = Range(worksheets("sheet1").UsedRange.Address).Rows.Count
LowAddress = "$B$1"

For FLoop = 1 To LastRow
If Range("B" & FLoop).Value < Range(LowAddress).Value And Range("B" & FLoop).Value <> "" Then
LowAddress = Range("B" & FLoop).Address
End If
Next FLoop
Range(LowAddress).Interior.ColorIndex = 3
End Sub