Comparing cell values in multiple columns

[JimH]

I'd like to (1) compare prices in several columns of data, (2) determine the lowest value, (3) highlight that cell, and (4) put that value in another cell.

 

[Aladin Akyurek]

On 2002-05-08 23:20, JimH wrote:
I'd like to (1) compare prices in several columns of data, (2) determine the lowest value, (3) highlight that cell, and (4) put that value in another cell.

Lets say that you have

Item1 in A2;
Price1 in B2;
Price2 in C2;
Price3 in D2.

You could use in E2:

=MIN(B2:C2)

If you want to hilite the lowest value, you can then use the formula in conditional formatting

=B2=E$2

 

[JimH]

I need to highlight the lowest value in L2:N2. Do I use the formula =L2=J$2 in conditional formatting in L2 and copy it to M2 and N2? I tried this and it doesn't work.