Standard excel document with 2 sheets in office 2010
How can 2 rows be compare and highlight the values, when the value shows in both list.
Sheet 1 | Sheet 2
Now I excel need to automatically highlight the value 1234 because it show in both rows.
Current I try to get this done by using the COUNTIF statement
As soon I hit enter I got an error message, the formula you typed in contains an error.