Conditional formatting is conditional on an event or data - if the there
is nothing to base it on it can't happen.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=510492