Dear Friends,
I have a sheet in which cells are linked from other sheets. I just want to ensure that all links are correct or not.
I know that the CTRL + [ will take me to Source cell.
But, I just want to "Change the color of Font" of all SOURCE cells that are linked in compilation sheet.
Request your kind help with a VBA to change font color of all source cells that are linked in a sheet. i.e. bulk execution for CTRL + [
One more addition:
The linked cell is in a formula like -So, the VBA to identify all sources referred in the formula and mark the values of source cells in "Red".![]()
=SUM('MasterData'!I207,'MasterData'!I208,'MasterData'!I209)
Please help me.
Bookmarks