Worksheet_Change - compare columns

[If]

Hello,

I would like to compare two columns (Column I and J) and if the value is
not the same place the text in red (column J).

I would use Worksheet_Change for this to be automatic but I do not see how.


Is it possible?

Thanks for your help.

 

[Don Guillett]

Hello,

I would like to compare two columns (Column I and J) and if the value is
not the same place the text in red (column J).

I would use Worksheet_Change for this to be automatic but I do not see how.

Is it possible?

Thanks for your help.

You can also do this with conditional formatting