That formula works VBA but the really small values assigned to the cell
that are hidden still have an effect on the conditional formatting.
Whats even worse is there are some other cells that are working fine
and do not have those pesky small values messing with the conditional
formatting and I cannot figure out why some cells have the really small
decimal values and other cells do not. Why?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=564803