如果一组单元格包含与其他表相关联的公式，输出不同的值，该如何触发宏

I am running the following macro to apply conditional formatting on a range of cells. What I want is the macro to be triggered anytime those cell values change. The cell values are not changed manually (i.e. they aren't selected by a user and changed), they change automatically because they contain formulas linked to cells in other spreadsheets.I am running the following macro to apply condi