Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
cheapest price
i have an excel spreadsheet showing various products and prices. I would like to use a conditional format that highlights the item with the cheapest price in the list. As the prices change, i would like the highlight cheapest to change dynamically. How do i do this -- craigproudfoot ------------------------------------------------------------------------ craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709 View this thread: http://www.excelforum.com/showthread...hreadid=483935 |
#2
|
|||
|
|||
cheapest price
try
formatconditional formatformula is =a2=min(a:a)format as desiredcopy format to other cells -- Don Guillett SalesAid Software "craigproudfoot" <craigproudfoot.1yaejm_1131636325.9465@excelforu m-nospam.com wrote in message news:craigproudfoot.1yaejm_1131636325.9465@excelfo rum-nospam.com... i have an excel spreadsheet showing various products and prices. I would like to use a conditional format that highlights the item with the cheapest price in the list. As the prices change, i would like the highlight cheapest to change dynamically. How do i do this -- craigproudfoot ------------------------------------------------------------------------ craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709 View this thread: http://www.excelforum.com/showthread...hreadid=483935 |
#3
|
|||
|
|||
cheapest price
=MIN($A$2:$A$5)=A2
A2:A5 is the list. A2 is the top-left item in the selection. Use "Formula is" "craigproudfoot" wrote: i have an excel spreadsheet showing various products and prices. I would like to use a conditional format that highlights the item with the cheapest price in the list. As the prices change, i would like the highlight cheapest to change dynamically. How do i do this -- craigproudfoot ------------------------------------------------------------------------ craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709 View this thread: http://www.excelforum.com/showthread...hreadid=483935 |
#4
|
|||
|
|||
cheapest price
Select all the cells, FormatConditional Formatting,
Cell value is, equal to, =MIN($A$!:$A$20) and apply a Pattern -- Kind regards, Niek Otten "craigproudfoot" <craigproudfoot.1yaejm_1131636325.9465@excelforu m-nospam.com wrote in message news:craigproudfoot.1yaejm_1131636325.9465@excelfo rum-nospam.com... i have an excel spreadsheet showing various products and prices. I would like to use a conditional format that highlights the item with the cheapest price in the list. As the prices change, i would like the highlight cheapest to change dynamically. How do i do this -- craigproudfoot ------------------------------------------------------------------------ craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709 View this thread: http://www.excelforum.com/showthread...hreadid=483935 |
#5
|
|||
|
|||
cheapest price
Thanks, that formula works - i need to know only 2 more things - firstly, how do i make the whole row change to the formatted colour and not just the single cell with the lowest number and (here i think it gets complicated) the conditional format does not seem to apply when i filter the list of prices. how can i get this to work? -- craigproudfoot ------------------------------------------------------------------------ craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709 View this thread: http://www.excelforum.com/showthread...hreadid=483935 |
#6
|
|||
|
|||
cheapest price
Hi Craig
Mark the whole range of data that you want the CF to apply to e.g. A2:M10 In the formula for the conditional formatting, instead of MIN() use SUBTOTAL(5,) =$A2=SUBTOTAL(5,$A$2:$A$10) Change ranges to suit. Regards Roger Govier craigproudfoot wrote: Thanks, that formula works - i need to know only 2 more things - firstly, how do i make the whole row change to the formatted colour and not just the single cell with the lowest number and (here i think it gets complicated) the conditional format does not seem to apply when i filter the list of prices. how can i get this to work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Formula for calculating price | Excel Discussion (Misc queries) | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
Macro's for figuring Price Lists?!? | Excel Discussion (Misc queries) | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions |