Changing Colors between linked sheets

  • Thread starter Thread starter Helene
  • Start date Start date
H

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?
 
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)
 
Back
Top