Posts by davetan

Can you help me how to close the tread Roy?

It works great.

I have used conditional formatting to highlight the cells.

Need to put comment so other user will know why it is highlight.

Thank you Roy

Thank you Roy

Dear All,

I use this code to add comments.

If A1 is different from B1 than comments "Value not equal"

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rCell As Range
Dim rReff As Range


Set rCell = Range("A1")
Set rReff = Range("B1")
On Error Resume Next
rCell.Comment.Delete
On Error GoTo 0
If rCell.Value <> rReff.Value Then rCell.AddComment ("Value not equal")
End Sub

How to make it work for range? Say i want to compare Range Ä1:A10 to B1:B10.

Thank you for your help.

Regards,

Davetan