Need help with Linking / Delinking Excel Files

Hi, I use a lot of excel reports which have multiple links from other excel files.
These linking almost run up to 100s and quality check for formulae and data accuracy becomes almost impossible. I need help in making this less complex. e.g. is there a way that all cells that have a formula gets coloured coded so that I know which ones to check.

Hi,

1. Use a function to test if there is formula
2. Create conditional formatting with this function

Public Function IsFormula(rng As Range) 
  If rng.Count > 1 Then 
      IsFormula = CVErr(xlErrRef) 
  Else 
     IsFormula = rng.HasFormula 
  End If 
End Function

HTH
Carim