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