How to reconcile two data sets and identify the nulls

[kwame84]

I have two data sets that need to be reconciled. DataSet1 is the source of truth and DataSet2 is what's been entered by the user in our system. DataSet2 should match DataSet1 in a perfect world, but it doesn't. I need to identify the null (0) values for the dates for each person in DataSet2 based off DataSet1. Hope this makes sense. It would be great if I could insert a "1" highlighted red in DataSet2 for the missing values. Please please help!!

DataSet1:

Label	3/1	3/2	3/3
Person1	0	1	1
Person2	1	1	1
Person3	0	0	1

DataSet2:

Label	3/1	3/2	3/3
Person1	0	0	1
Person2	1	0	1
Person3	0	0	0

[FlameRetired]

Hello kwame84. Welcome to the forum.

In the attached Conditional formatting is applied to B9:D11.

In Format Manager a formula defines what applies.

Please Login or Register  to view this content.

The formatting is Fill > Red and Custom format General "1"

[kwame84]

Thank you Dave! It worked perfectly!

[FlameRetired]

Good to hear. You are welcome, and thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.