The Change event won't be triggered by a formula, so you would have to use the Calculate event, but that doesn't provide a Target argument telling you what (if anything) changed, so you would have to store the old values of every cell you were interested in and then check all of them whenever the sheet recalculates. This would probably be quite processor intensive (depending on amount of data and how many cells you want to monitor) and might slow your worksheet down too much. How many cells do you want monitored?