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