Detect change in cell with formula

[lgarcia3]

I have a cell which is changing constantly. I need to detect when that specific cell changes. I know I can use Worksheet_Change event to detect that; the problem is that this event does not detect when the change is in a cell with a formula (or at least not that I know). This specific cell has a formula. So how can I capture that?
Thanks!

[Trebor76]

Hi,

Say the formula is in cell A1, its' result is 10 and any other value will result in the cell shading changing to red, try the following code within the Worksheet_Change event for the relevant sheet:

If Range("A1").Value = 10 Then
        Range("A1").Interior.ColorIndex = xlNone
    Else
        Range("A1").Interior.ColorIndex = 3 'Red
    End If

Hope this helps.

Kind regards,

Robert