By the way , conditional formatting works if you refer to names. Say,
you have a region "A1" on the Sheet1 called "Region1". You can refer to
"Region1" in your cond. formatting formula on the Sheet2. But you can't
do the same with "A1".


--
5631
------------------------------------------------------------------------
5631's Profile: http://www.excelforum.com/member.php...o&userid=33022
View this thread: http://www.excelforum.com/showthread...hreadid=541517