Highlight lowest price in a row.
 

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.

Highlight lowest price in a row.
 

formatconditional formattingformula is =j2=max(J:J)format as desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chadboehne" wrote in message
...
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.

Highlight lowest price in a row.
 

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.

"chadboehne" wrote:

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.

Highlight lowest price in a row.
 

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" wrote in message
...
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.

"chadboehne" wrote:

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.

Highlight lowest price in a row.
 

Don: Why did you use Max instead of Min?

"Don Guillett" wrote:

formatconditional formattingformula is =j2=max(J:J)format as desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chadboehne" wrote in message
...
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.

Highlight lowest price in a row.
 

It's the thought that counts

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joel" wrote in message
...
Don: Why did you use Max instead of Min?

"Don Guillett" wrote:

formatconditional formattingformula is =j2=max(J:J)format as desired

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chadboehne" wrote in message
...
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.

Highlight lowest price in a row.
 

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

"Bob Phillips" wrote:

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" wrote in message
...
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.

"chadboehne" wrote:

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.