Thread
:
cheapest price
View Single Post
#
2
Don Guillett
Posts: n/a
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
Reply With Quote