Comparing intersecting cell on two different sheets - one non-pivot to a pivot table

[ExcelHelp9012]

Hello all,

Sorry for the crazy thread title. I'm not sure how to best word this. I've got some data that I need to be able to compare between two different worksheets. One worksheet has the data going in the wrong direction, so I've used a pivot table to change the way the data is laid out.

I've got the two sheets pretty close now in terms of the way the data is laid out but the first sheet will not be a pivot table and the other sheet to compare against will be a pivot table if that matters.

On Sheet 1 columns I have

Name | Date1 | Date2 | Date 3| etc

For Sheet 1 rows I have

Value for name(ex John) | A numerical value (ex 8)


On Sheet 2 (the pivot table) I have basically the same exact column/rows.

What I need to do is find the intersection of Name/Date in Sheet 1 and find the value in the intersecting cell (always a number, let's say 8) - then I need to go into Sheet 2 and find the same Name/Date intersection and compare to the value in that cell. I want to highlight RED if the values to not match.

An example could be on Sheet 1:
* John has 8 for 1/1/2023
On Sheet 2 (the pivot table)
* John has 0 for 1/1/2023

I would want this to be highlighted in red since they do not match.

I'm sorry for the clunky description here and I'm more than happy to explain further if need.

Thank you so much for your time and guidance here.