Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |