Thanks so much - that totally helped!
Now is it possible to do this dynamically? So that if I change a value
of a color in sheet one it would reflect in Sheet 2?
--
pikakathy
------------------------------------------------------------------------
pikakathy's Profile:
http://www.excelforum.com/member.php...o&userid=30320
View this thread:
http://www.excelforum.com/showthread...hreadid=499837