With condition formatting it is not possible as condition formatting
only does formatting. I believe tha only way to do it via a macro.
Maybe you could ask this question in the programming section of this
forum.
Rgds.
--
Infinity
------------------------------------------------------------------------
Infinity's Profile:
http://www.excelforum.com/member.php...o&userid=32725
View this thread:
http://www.excelforum.com/showthread...hreadid=527524