Assuming that your cell reference is static on all sheets (meaning same
cell location Ex: B214), I don't see how this formula wouldn't work.
If they aren't static, can they be formatted to be?


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=495242