Worksheet_Change - compare columns

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.
 
D

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

You can also do this with conditional formatting
 
Top