I have three open sheets
1. Sheet 1("Holds")
2. Sheet 2 ("Changes")
3. Sheet 3 ("Summary")

Sheet Three (Summary)has formulas that look like the following (=Sum('Holds'! D5 + Changes!D5) That go all the way to column L down to row 77
So lots of different values

I want to have a VBA statement that changes the color of the cell in the summary where I made changes in the second sheet "Changes")
Conditional formatting will not work due to all the different values and each month I have to change the Holds sheet 1 and I don't want my summary page to change.

Does anyone have any idea how to write an If then statement For the Whole sheets