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.

On Sep 28, 4:45*pm, If wrote:
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