Need VBA code to change color of cells with external links

[tst2000]

How do I create a VBA code that selects all of the cells in a workbook that contain external links and changes the font of those cells to green?

[Dreambringer]

First, how are the cells formatted? with =HYPERLINK? Are all your external links http?

[tst2000]

No hyperlinks. Just regular formulas that reference external workbooks. I need a macro that loops through each sheet in my workbook to find the external formulas and change the color of those cells.

[JieJenn]

try this see if works

Please Login or Register  to view this content.

[tst2000]

No That doesn't do anything. That code seems to be looking for Hyperlinks and theer are no Hyperlinks in my workbook... also I don't see where it is changing the cell color anywhere in the code.