Conditional Formating
 

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

Conditional Formating
 

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

Conditional Formating
 

Works Great,Thanks

"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

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