Conditional Formating
Can You also tell me how to make this apply to numerous products
"Peo Sjoblom" wrote:
Assume the values are in A1:C1
select A1:C1 with A1 as active (if you select from A1 it will be active)
formatconditional 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)
"Trying To Excel" wrote in message
...
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
|