Row by row comparison between 2 sheets - conditional formatting (changes/duplicates)

[crtk09]

Hey all! I'm trying to create a formula that can be used with conditional formatting to highlight changes, or duplicates, between 2 sheets, or 2 workbooks if that works better, on a row-by-row basis, for a week-by-week sales audit that we generate. I've tinkered with a bunch I've found online, but for whatever reason just cannot seem to find the "right one".

You'll find an example below with some dummy data (this is the exact formatting we use) to give you an idea of what I'm looking at. These sheets will often contain different orderings and new additions, as well as deletions of cancelled/completed orders. Any help would be greatly appreciated!

1 18 22:

MrExcel Sheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Customer Name	Order Number	Quote #	Line Number	Item Number	Ordered Quantity	Business Unit	Order Line Type	Line Flow Status	Created By	L Creation Date	Actual Completion Date	Currency	Unit Selling Price	Net	USD Net
2	ABC	2000728	IC-00127787-V11	00019	ROW-SALES-DEV	0	Networking	SHIP_NO_CHARGE	Canceled	N/A	31-Dec-21		USD	2,400	0.00	0.00
3	DEF	2000728	IC-00127787-V11	00020	S-DEV-WFH	1	Development	INVOICE_ONLY	Closed	N/A	31-Dec-21	28-Sep-21	USD	3,500	3,500.00	3,500.00
4	GHI	2000986	IC-0078103-03089	00004	SAL-ENG-QA	2	Broadcast	IN_STOCK	Closed	N/A	13-Oct-21	2-Dec-21	USD	0	0.00	0.00
5	JKL	2001611	IC-0080368-05726	00005	QA-MOV-IN	3	Networking	CREDIT_ONLY	Closed	N/A	29-Dec-21	30-Dec-21	USD	1,185	1,185.30	1,185.30
6	MNO	2001052	IC-0073713-02680	00006	ROW-SALES-DEV	55	Development	IN_STOCK	Closed	N/A	25-Oct-21	16-Dec-21	EUR	1,194	3,582.60	4,171.94
7	MNO	2001052	IC-0073713-02679	00005	S-DEV-WFH	2	Broadcast	IN_STOCK	Closed	N/A	30-Oct-21	16-Dec-21	EUR	1,185	5,000.00	4,500.00
8	PQR	2000989	No quote	00007	S-DEV-WFH	66	Broadcast	IN_STOCK	Closed	N/A	15-Oct-21	22-Dec-21	USD	1,960	3,920.00	3,920.00
9	STU	2262547	IC-00125104-V8	00004	SAL-ENG-QA	1001	Networking	IN_STOCK	Closed	N/A	11-Jul-21	13-Sep-21	USD	1,098	40,624.89	40,624.89
10	VW	2000997	IC-00126474-V2	00004	QA-MOV-IN	15.5	Development	IN_STOCK	Awaiting Shipment	N/A	15-Oct-21	21-Dec-21	USD	2,100	116,800.01	116,800.01
11	XYZ	2000997	IC-00126474-V2	00005	QA-MOV-IN	36.8	Broadcast	IN_STOCK	Awaiting Shipment	N/A	15-Oct-21		USD	2,100	58,399.99	58,399.99
11822

1 10 22:

MrExcel Sheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Customer Name	Order Number	Quote #	Line Number	Item Number	Ordered Quantity	Business Unit	Order Line Type	Line Flow Status	Created By	L Creation Date	Actual Completion Date	Currency	Unit Selling Price	Net	USD Net
2	ABC	2000728	IC-00127787-V11	00019	ROW-SALES-DEV	0	Networking	SHIP_NO_CHARGE	Canceled	N/A	31-Dec-21		USD	2,400	0.00	0.00
3	DEF	2000728	IC-00127787-V11	00020	S-DEV-WFH	1	Development	INVOICE_ONLY	Closed	N/A	31-Dec-21	28-Sep-21	USD	3,500	3,500.00	3,500.00
4	GHI	2000986	IC-0078103-03089	00004	SAL-ENG-QA	1	Broadcast	IN_STOCK	Awaiting Shipment	N/A	14-Oct-21	2-Dec-21	USD	500	500.00	500.00
5	JKL	2001611	IC-0080368-05726	00005	QA-MOV-IN	1	Networking	CREDIT_ONLY	Closed	N/A	29-Dec-21		USD	1,185	1,185.30	1,185.30
6	MNO	2001052	IC-0073713-02680	00006	ROW-SALES-DEV	55	Development	IN_STOCK	Awaiting Shipment	N/A	25-Oct-21		EUR	1,194	3,582.60	4,171.94
7	PQR	2000989	No quote	00004	S-DEV-WFH	21	Broadcast	IN_STOCK	Closed	N/A	15-Oct-21		USD	1,960	3,920.00	3,920.00
8	STU	2262547	IC-00125104-V8	00004	SAL-ENG-QA	500	Networking	IN_STOCK	Closed	N/A	11-Jul-21	13-Sep-21	USD	1,098	40,624.89	40,624.89
9	VW	2000997	IC-00126474-V2	00004	QA-MOV-IN	5	Development	IN_STOCK	Awaiting Shipment	N/A	15-Oct-21	21-Dec-21	USD	2,100	116,800.01	116,800.01
10	XYZ	2000997	IC-00126474-V2	00005	QA-MOV-IN	25	Broadcast	IN_STOCK	Awaiting Shipment	N/A	15-Oct-21		USD	2,100	58,399.99	58,399.99
11022

 

[crtk09]

Should probably clarify this a little more and to what I'm trying to accomplish:
-Find and compare a row by matching the various columns and their contents
-If anything has changed, highlight it

 

[crtk09]

Might be making headway on this, but would still love to hear from anyone regarding this! Tricky one considering the consistently changing data, orders they're delivered in, and the amount that I receive!