| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
Hi. I have a table where I have to select the lowest price in each row for
several options (suppliers). e.g. I have values in columns J, O, R, U, X from row 15 to row 44. How may I be able to color the best price for each row? I tried using the MIN formula in the Conditional Formatting but unfortunately I don´t understand very well how this option (Conditional Formatting) works. and I don´t get the correct result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Price List overall price increase | Excel Discussion (Misc queries) | |||
| base price list compute on to another price list? on excel work sh | Excel Discussion (Misc queries) | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Threaded Mode
