Assuming you have the code in the TOTAL sheet as instructed, on the
TOTAL sheet select the cell with the formula: =Data!H32 and press F2
then ENTER. (this will trigger the worksheet_change for this cell).

What happens to the cell fill color?

If Data!H32 contains the value 1, the cell should turn Blue.

Note this code is only triggered when a cell within the specified range
(Target, Me.Range("A1:DM114") in your example) changes and then only on
THAT cell.

I'm guessing this is not going to meet your needs as you would need to
manually recalculate the range, cell by cell.

Hopefully, someone can come up with a better solution for you.

Sorry.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=472580