You can apply conditional formatting just as in an un-linked cell. The
formatting (conditional or un-conditional) does not link directly:

If A1 contains =Z100, then A1 will display the value of Z100, not its format.

If this is what you want to accomplish, then copy Z100 and
paste/special/format into A1.
--
Gary''s Student


"Newbie" wrote:

Hi,

Is there a way to conditionally format cells that contain either a local
link, external link or typed value?

Thanks.