I have a list of prices in a list (column F) which has a CF attached to
the whole column to highlight the lowest number in blue.
When i apply a filter to column B and reduce the overall list of
numbers in column F, the conditional format disappears or rather, it
does not highlight the lowest number in the new reduced list.
Example: say the lowest number in the unfiltered (column F) list is
2.5
The number 2.5 becomes highlighted in blue
When i apply a filter to column B, the lowest number in the resulting
list (column F)is not highlighted in blue (unless of course the
resulting list still contains the number 2.5)
i'm sure the above is incomrehensible - my apologies.


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