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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
select row formula is
=a3=min($a$3:$x$3) format as desired. -- Don Guillett Microsoft MVP Excel SalesAid Software "PaulinaDi" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
Unfortunately I didn´t understand what to do.
I would like this formula to take me all the range once but select for each row the best price. e.g. column J O R U X row 15 10 11 9 8 5 16 13 12 11 8 14 17 20 12 5 13 16 18.... 19.... 44.... I would like on row 15 the number 5 be selected, on row 16 number 8 selected, on row 17 number 5 to be selected and so on. "Don Guillett" wrote: select row formula is =a3=min($a$3:$x$3) format as desired. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
PaulinaDi wrote:
Unfortunately I didn´t understand what to do. I would like this formula to take me all the range once but select for each row the best price. e.g. column J O R U X row 15 10 11 9 8 5 16 13 12 11 8 14 17 20 12 5 13 16 18.... 19.... 44.... I would like on row 15 the number 5 be selected, on row 16 number 8 selected, on row 17 number 5 to be selected and so on. Select (in this order, by holding down the Ctrl key while clicking and dragging) J15:J44, O15:O44, R15:R44, U15:U44 and X15:X44. X15 should be the active cell and the others also highlighted. Select Conditional Formatting. Change the pop-up from "Cell Value Is" to "Formula Is". Change the Format as desired (bold, outlined, shaded, etc.). Enter the following for the formula: =X15=MIN($J15,$O15,$R15,$U15,$X15) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
Yes. I got it. It really works. And if I decide to increase columns, do I
have to do all the procedure again? or just select all the range again and change the formula but using the one entered before? "Glenn" wrote: PaulinaDi wrote: Unfortunately I didn´t understand what to do. I would like this formula to take me all the range once but select for each row the best price. e.g. column J O R U X row 15 10 11 9 8 5 16 13 12 11 8 14 17 20 12 5 13 16 18.... 19.... 44.... I would like on row 15 the number 5 be selected, on row 16 number 8 selected, on row 17 number 5 to be selected and so on. Select (in this order, by holding down the Ctrl key while clicking and dragging) J15:J44, O15:O44, R15:R44, U15:U44 and X15:X44. X15 should be the active cell and the others also highlighted. Select Conditional Formatting. Change the pop-up from "Cell Value Is" to "Formula Is". Change the Format as desired (bold, outlined, shaded, etc.). Enter the following for the formula: =X15=MIN($J15,$O15,$R15,$U15,$X15) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hghlight the best price for each row
In which case, just change the suggested
=a3=min($a$3:$x$3) to =J15=min($J15,$O15,$R15,$U15,$X15) as the formula to be used in Conditional Formatting/ Formula Is. -- David Biddulph "PaulinaDi" wrote in message ... Unfortunately I didn´t understand what to do. I would like this formula to take me all the range once but select for each row the best price. e.g. column J O R U X row 15 10 11 9 8 5 16 13 12 11 8 14 17 20 12 5 13 16 18.... 19.... 44.... I would like on row 15 the number 5 be selected, on row 16 number 8 selected, on row 17 number 5 to be selected and so on. "Don Guillett" wrote: select row formula is =a3=min($a$3:$x$3) format as desired. |
Reply |
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) |