Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19

I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?

Hi Timothy,

Use conditional formating to highlight it, chose "the formula is" and put:

=B2=$d$1

Assuming that you have the minimmum formula on the D1 cell;

regards from Brazil

Marcelo



"Timothy Langaster" escreveu:

Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19

I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?

Dear Marcelo,

Thank you for your prompt reply.
I'll try it.

Best Regards
Timothy Langaster


"Marcelo" wrote:

Hi Timothy,

Use conditional formating to highlight it, chose "the formula is" and put:

=B2=$d$1

Assuming that you have the minimmum formula on the D1 cell;

regards from Brazil

Marcelo



"Timothy Langaster" escreveu:

Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19

I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?

Dear Marcelo,

Probably I dont make clear that I need the price for the cheaper supplier
to be highlight and not the result (see prices with asterisks - these prices
to be highlight)
See below:

Description 1stSupplier B Supplier Cheaper Price
Apple **1.5 1.75 1.5 MIN($B1:$C1)
Pears 2.2 **2.15 2.15
Bananas **3.6 3.8 3.6
Pineapple **4.85 5.2 4.85

Did you have any idea how its possible?

Thank you in advance.



"Marcelo" wrote:

Hi Timothy,

Use conditional formating to highlight it, chose "the formula is" and put:

=B2=$d$1

Assuming that you have the minimmum formula on the D1 cell;

regards from Brazil

Marcelo



"Timothy Langaster" escreveu:

Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19

I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?