It should evaluate everytime the worksheet is calculated (including whe
enter a new value in a cell). If you want it to update anytime yo
change the color of a cell, I'm afraid you may be out of luck sinc
there is no event triggered when this happens.

You can add it to the Worksheet_SelectionChange event so that it wil
evaluate anytime a new cell is clicked. I.e.:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub

If you are making the changes to the color via code, you can use th
Application.Calculate at the end of your code that makes the change
and get it to update.



--
Message posted from http://www.ExcelForum.com