Excel Differences between two worksheets but worksheets have dependent columns

Samantha Huie 0 Reputation points
2024-07-02T19:50:39.59+00:00

I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to take into account Column A and Column B must match on both worksheets. If they do not match, then highlight the row that does not match.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,677 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,688 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Barry Schwarz 2,511 Reputation points
    2024-07-02T21:42:02.54+00:00

    On sheet1, select the range of cells in column A to be checked. For example, A9:A22. On the Home tab, select Conditional Formatting -> New Rule -> Use a formula. Enter the formula "=sheet1!a9<>sheet2!a9" without the quotes. Click OK several times and force a mismatch in the data to test.

    Repeat for column B