Highlight lowest price in a row.

[chadboehne]

I have multiples cells with the lowest prices from different vendors. I need
to automatically highlight the lowest price in each row of cells without
sorting the data. I would like the numbers to be Bold Red and the Background
to be Yellow.

 

[Don Guillett]

format>conditional formatting>formula is =j2=max(J:J)>format as desired

 

[Joel]

Use conditional formating with "formula equals"

Use the following formula in cell A1. Min(1:1) is the entire row 1.
=IF(A1=MIN(1:1),TRUE,FALSE)
Then select the Font to be Red and the Pattern to be yellow.

To copy conditional formating to other cells do the following:
Copy cell A1 and use Paste Special - Formats to copy this formula to other
cells.

 

[Bob Phillips]

There is no need for the TRUE/FALSE action as

=A1=MIN(1:1)

will return TRUE or FALSE quite happily

You might also want to cater for blanks

=AND(A1<>"",A1=MIN(1:1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Joel]

Don: Why did you use Max instead of Min?

format>conditional formatting>formula is =j2=max(J:J)>format as desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

It's the thought that counts

 

[chadboehne]

Thank you!!! I am the coolest guy in the office now...You guys are the best!