How to arrange Two excel sheets side by Side
Steps
- Click on View tab, Click on New Window
- Click on Arrange All, Select Vertical
Now to compare 2 Rows in 2 Excel Sheets
- Select the Rows in the Sheet which needs to be compared
- Click on Conditional Formatting Option
- =ISNA(MATCH(A2,Sheet2!A2,FALSE))
If you want the formatting to be applied only for one Column select that column and apply conditional formatting
Instead of
=$A$2:$B$7
it should be
=$A$2:$A$7
in Conditional Rules Formatting Manager