| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the lowest value in a row
I have a spreadsheet that has several Price fields per Vendor. I want to use
conditional formatting to find the lowest value in the three Price fields for each record so I can color code the lowest value. Does anyone know how to write the formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the lowest value in a row
Use this:
=A1=MIN(A:A) Great resource he http://www.mvps.org/dmcritchie/excel/condfmt.htm Regards, Ryan--- -- RyGuy "jlo" wrote: I have a spreadsheet that has several Price fields per Vendor. I want to use conditional formatting to find the lowest value in the three Price fields for each record so I can color code the lowest value. Does anyone know how to write the formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the lowest value in a row
Hi,
Select your cell; in my case A1 to E1 and then Format|Conditional format Formula is =A1=MIN($A$1:$E$1) Pick a colour OK Mike "jlo" wrote: I have a spreadsheet that has several Price fields per Vendor. I want to use conditional formatting to find the lowest value in the three Price fields for each record so I can color code the lowest value. Does anyone know how to write the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to find the lowest tender | Excel Discussion (Misc queries) | |||
| How do I find the position of the lowest value in a row? | Excel Discussion (Misc queries) | |||
| How to Find lowest value of 5 different cells? | Excel Discussion (Misc queries) | |||
| MIN to find specific lowest value | Excel Worksheet Functions | |||
| Find Lowest Bidder | Excel Worksheet Functions | |||
Linear Mode
