The following formula colours the lowest value cell in a list (even when
filtered) How can i make the formatting cover the full row? My formula
is as follows:

cell value is equal to =SUBTOTAL(5,$F:$F)


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216