VBA to change color when cell updated

[Nagaraj udupa]

I am tring to change color of a cell in a cell range("A10:F100") when ever a cell in a range is updated from previous value by formula due to change in other worksheet in earlier version of office(before 2007). Please help in this regard

 

[Learn Excel in Tamil]

Hi

Please try with this

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A10:F100")) Is Nothing Then

ActiveCell.Interior.Color = 49407

End If

End Sub

 

[Peter_SSs]

Hi

Please try with this

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A10:F100")) Is Nothing Then

ActiveCell.Interior.Color = 49407
[CODE]

End If

End Sub

[/CODE]

Worksheet_Change event code is not triggered if the cells changing values are the result of a formula, which by my understanding, is the case here.

Even if the cells were changed manually, your code will most likely not colour the changed cell. For example, if a value was entered in B14 and Enter pressed, with normal settings the active cell would then be B15 & that is the cell your code colours, not the changed cell B14

 

[Learn Excel in Tamil]

Agreed with you Peter, could you please share right coding, i am waiting to learn

Thanks

 

[Peter_SSs]

Agreed with you Peter, could you please share right coding, i am waiting to learn

I don't have any at the moment or I would have already posted it.

I am tring to change color of a cell in a cell range("A10:F100") when ever a cell in a range is updated from previous value by formula due to change in other worksheet ..

I'm not sure I will have a suitable answer anyway, but can you post the formulas from cells A10:F10?

 

[Nagaraj udupa]

HI,
The code given by Learn Excel in Tamil is not working

 

[Peter_SSs]

HI,
The code given by Learn Excel in Tamil is not working

In post 3 I already indicated that would be the case.

Also, in post 5, I asked you for more information - that you have not provided.