What's the condition you've established to identify the minimum? If you're
comparing the particular value to something like subtotal(5,range), then
you'll have issues, as the subtotal functions honor the filter. If that's
it, just change to min(range). If not, please post the condition you're
using in the CF.

"craigproudfoot" wrote:


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