Highlight lowest price in a row.

C

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.
 
J

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.
 
B

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)
 
Top