Need help with Linking / Delinking Excel Files

[joydeepghosh09]

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.

[Carim]

Hi,

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

Please Login or Register  to view this content.

HTH
Carim