Worksheet_Change - compare columns

  • Thread starter Thread starter If
  • Start date Start date
I

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.
 
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.
Click to expand...

You can also do this with conditional formatting
 
Back
Top