these part numbers appear red in a worksheet named Products
they are linked to another worksheet. How can I get the link to
automatically appear red as well?

AEPF18301A*
AEPF30361A*
AEPF42601A*
AEPT030-00*-1*
AEPT036-00*-1*
AEPT060-00*-1


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=536919