Hghlight the best price for each row
 

Hi. I have a table where I have to select the lowest price in each row for
several options (suppliers).
e.g. I have values in columns J, O, R, U, X from row 15 to row 44.
How may I be able to color the best price for each row?
I tried using the MIN formula in the Conditional Formatting but
unfortunately I don´t understand very well how this option (Conditional
Formatting) works. and I don´t get the correct result.

Hghlight the best price for each row
 

select row formula is
=a3=min($a$3:$x$3)
format as desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PaulinaDi" wrote in message
...
Hi. I have a table where I have to select the lowest price in each row for
several options (suppliers).
e.g. I have values in columns J, O, R, U, X from row 15 to row 44.
How may I be able to color the best price for each row?
I tried using the MIN formula in the Conditional Formatting but
unfortunately I don´t understand very well how this option (Conditional
Formatting) works. and I don´t get the correct result.

Hghlight the best price for each row
 

Unfortunately I didn´t understand what to do.
I would like this formula to take me all the range once but select for each
row the best price.
e.g.

column J O R U X
row
15 10 11 9 8 5
16 13 12 11 8 14
17 20 12 5 13 16
18....
19....
44....

I would like on row 15 the number 5 be selected, on row 16 number 8
selected, on row 17 number 5 to be selected and so on.

"Don Guillett" wrote:

select row formula is
=a3=min($a$3:$x$3)
format as desired.

Hghlight the best price for each row
 

PaulinaDi wrote:
Unfortunately I didn´t understand what to do.
I would like this formula to take me all the range once but select for each
row the best price.
e.g.

column J O R U X
row
15 10 11 9 8 5
16 13 12 11 8 14
17 20 12 5 13 16
18....
19....
44....

I would like on row 15 the number 5 be selected, on row 16 number 8
selected, on row 17 number 5 to be selected and so on.



Select (in this order, by holding down the Ctrl key while clicking and dragging)
J15:J44, O15:O44, R15:R44, U15:U44 and X15:X44. X15 should be the active cell
and the others also highlighted.

Select Conditional Formatting. Change the pop-up from "Cell Value Is" to
"Formula Is". Change the Format as desired (bold, outlined, shaded, etc.).
Enter the following for the formula:

=X15=MIN($J15,$O15,$R15,$U15,$X15)

Hghlight the best price for each row
 

Yes. I got it. It really works. And if I decide to increase columns, do I
have to do all the procedure again? or just select all the range again and
change the formula but using the one entered before?

"Glenn" wrote:

PaulinaDi wrote:
Unfortunately I didn´t understand what to do.
I would like this formula to take me all the range once but select for each
row the best price.
e.g.

column J O R U X
row
15 10 11 9 8 5
16 13 12 11 8 14
17 20 12 5 13 16
18....
19....
44....

I would like on row 15 the number 5 be selected, on row 16 number 8
selected, on row 17 number 5 to be selected and so on.



Select (in this order, by holding down the Ctrl key while clicking and dragging)
J15:J44, O15:O44, R15:R44, U15:U44 and X15:X44. X15 should be the active cell
and the others also highlighted.

Select Conditional Formatting. Change the pop-up from "Cell Value Is" to
"Formula Is". Change the Format as desired (bold, outlined, shaded, etc.).
Enter the following for the formula:

=X15=MIN($J15,$O15,$R15,$U15,$X15)

Hghlight the best price for each row
 

In which case, just change the suggested
=a3=min($a$3:$x$3)
to
=J15=min($J15,$O15,$R15,$U15,$X15)
as the formula to be used in Conditional Formatting/ Formula Is.
--
David Biddulph


"PaulinaDi" wrote in message
...
Unfortunately I didn´t understand what to do.
I would like this formula to take me all the range once but select for
each
row the best price.
e.g.

column J O R U X
row
15 10 11 9 8 5
16 13 12 11 8 14
17 20 12 5 13 16
18....
19....
44....

I would like on row 15 the number 5 be selected, on row 16 number 8
selected, on row 17 number 5 to be selected and so on.

"Don Guillett" wrote:

select row formula is
=a3=min($a$3:$x$3)
format as desired.