highlight cells that have dependents
 

Hi,

I have a column of cells, some of which have dependents in other sheets in
the same workbook, and some of which don't. I'd like to highlight the cells
that do have dependents. I've tried using the Dependents and the
DirectDependents properties in Visual Basic, but they only seem to work in
the active sheet, and all my cells have dependents in other sheets.

I have more than 6000 rows, so i wouldn't want to do it manually. Any
suggestions?

Thanks!