Conditional Formating

[Guest]

I am looking for the best price to make a purchase.
A B C
Product 5 6 7

I would like to choose lowest price by changing it to a red font

 

[Peo Sjoblom]

Assume the values are in A1:C1

select A1:C1 with A1 as active (if you select from A1 it will be active)

format>conditional formatting, formula is

=A1=MIN($A$1:$C$1)

click format and select red font, click OK twice

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

Works Great,Thanks

Assume the values are in A1:C1

select A1:C1 with A1 as active (if you select from A1 it will be active)

format>conditional formatting, formula is

=A1=MIN($A$1:$C$1)

click format and select red font, click OK twice

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

Can You also tell me how to make this apply to numerous products