Perhaps if I restate my problem. The VBA coding used to work fine on my XP system. The coding worked the first time I opened your file, once saved on the Windows 7 system it will not work when opened again. If I open it from your link in this thread the coding no longer works as it did the first time.
All instances of formula recalculation is set to automatic.
The conditional formatting changes when F9 is pressed in all instances.

Two questions, what in the VBA recalculates the worksheet to invoke the conditional formatting when the cell location is changed; and, what is so different in Windows 7 interacting with Excel 2007 than XP to make this glitch happen and how to fix it?