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

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

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

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

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

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?