Is It possible to a macro which can perform the following function?


For each cell in the selected area, if the cell has Dependents which is not on the same sheet, then the cell will be given red colour.

Thanks