offset column for the matched cell of column A in conditional formatting

[newexcler]

Dear Experts,

I am sure, this would have been asked and it might be on a tip of your fingers, but if you ask me, Happy to provide sample.
Here is the problem

I have to write conditional formatting to highlight 4 columns, comparing this list of data1 to another list of data2 which is not ordered.
So I have two tables to compare each element to highlight


Say in this example:

Once I find the match for column A, say each element of data 1 with data 2, I want to anchor that match to calculate the row number and offset columns to compare each element after the first match.
Note: It is my assumption that data from two sources are in same order of columns, so I can do offset.

What I tried, I found the match using countif but I cannot get the cell reference so I comparing first coumn of each table using cell("address",Index( match)) but this gives me right reference when I pass this to Offset function, I am facing issues. As I have multiple dates, I am thinking only option is offset but happy to have any solution, you think is best.

Please can someone suggest a better way to offset so that I can pass that formula in the conditional format to highlight them, I will extend this to corresponding columns.

List of data1:

Orange	Origin1	02/20/2021
Apple	Origin2	02/22/2021
Kale	Origin2	02/22/2021
Cucumber	Origin3	02/22/2021

List of data 2

Apple	Denver	02/22/2021	...
Orange	Texas	05/21/2021	...
Banana	Denver	03/15/2020	...

 

[Fluff]

Are you trying to highlight the date if it does not match the relevant date in data2?

 

[newexcler]

Are you trying to highlight the date if it does not match the relevant date in data2?

Thank you Fluff for getting back. Yes Highlight any missing element in both data1 and data2. Two-way lookup.

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C
1	Orange	Origin1	20/02/2021
2	Apple	Origin2	22/02/2021
3	Kale	Origin2	22/02/2021
4	Cucumber	Origin3	22/02/2021
Sheet1

+Fluff 1.xlsm
	A	B	C
1	Apple	Denver	22/02/2021
2	Orange	Texas	21/05/2021
3	Banana	Denver	15/03/2020
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C3	Expression	=C1<>INDEX(Sheet1!$C$1:$C$4,MATCH($A1,Sheet1!$A$1:$A$4,0))	text	NO

 

[newexcler]

Thank you Fluffy, this worked like charm. Thanks a ton.

 

[Fluff]

You're welcome & thanks for the feedback.