Changing Colors between linked sheets

[Helene]

I have the formatted cells in my 'master' in red type
font. When I link another spreadsheet to this master, I
would like all the linked cells in red. This way I can
see quickly what has been linked and what is 'on its own'
without having to tab cell by cell. Is this possible?

 

[Frank Kabel]

Hi
you may try the following UDF (put in a module of your workbook)

Function is_formula(rng As Range)
is_formula = rng.HasFormula
End Function

Now select the range in your second sheet (e.g. A1:F100) and goto
'Format - Conditional Format' and enter the following formula
=IS_FORMULA(A1)

Note: this will color all cells with a formula 8not only with a link to
your other sheet)