=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
>
>