Conditional Formating

  • Thread starter Trying To Excel
  • Start date
T

Trying To Excel

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
 
P

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)
 
T

Trying To Excel

Works Great,Thanks

Peo Sjoblom said:
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)
Click to expand...
 
Top