highlight the cells

Hi,

I have spread sheet, in that some of the values are entered directly and some are linked to other file. Is there any way/program to highlight the cells with different color which are the values are referring from other file/sheet.

Regards
Sagar

Hi, Sagar. One easy way to do this is use CTRL + G, select Special, then Formulas, and click OK. Now format the cells to your liking. This will work well if the workbook is a template, and new formulas won't be added. If you want to do this dynamically, I believe you need to use VBA.

HTH

Jason

Hi Jason,

Thanks for your solution

Regards
Sagar

No problem, Sagar. Glad I could help.