compare for equal numbers and color code

[Memar]

I just want to compare two different reports total to check if the numbers in bold matches. For report A, the January 1 total number 800 is not correct comparing to report B. Because 200 item are not recorded so I wan to flag that with color or other best ways. The same with May 1 records. I want the color or flag to be in Report A in the total number Row or if the next row after the Total number.

Report A
1/1/2019 2/1/2019. 3/1/2019. 5/1/2019. Product identifier

​

​

[TABLE="width: 500"]
<tbody>[TR]
[TD]500[/TD]
[TD]100[/TD]
[TD]500[/TD]
[TD]200[/TD]
[TD]1235[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]100[/TD]
[TD]350[/TD]
[TD]100[/TD]
[TD]1234[/TD]
[/TR]
[TR]
[TD]800[/TD]
[TD]200[/TD]
[TD]850[/TD]
[TD]300[/TD]
[TD]1900[/TD]
[/TR]
</tbody>[/TABLE]


Report B
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date received[/TD]
[TD]store code [/TD]
[TD]amount [/TD]
[TD]Total Amount received by date and store [/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]12355[/TD]
[TD]500[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]12355[/TD]
[TD]300[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]12355[/TD]
[TD]200[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]2/1/2019[/TD]
[TD]12344[/TD]
[TD]100[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]2/1/2019[/TD]
[TD]12344[/TD]
[TD]100[/TD]
[TD]200[/TD]
[/TR]
</tbody>[/TABLE]
5/1/2019 12356 200. 500
5/1/2019. 12356 100. 500
5/1/2019. 12356. 200. 500

Thanks for your time and help.

 

[AhoyNC]

You could use Conditional Formatting.

Using the example below.
Highlight cells A5 to D5 (use your actual total row).
Then goto
-Conditional Formatting
-New Rule
-Use Formula
-Enter formula shown in cell A5 (again change cell ranges in formula to match your actual data).
-Format
-Fill (choose color you want)
-OK
-OK

Excel Workbook
	A	B	C	D	E
1	Report A
2	1/1/2019	2/1/2019	3/1/2019	5/1/2019	Product identifier
3	500	100	500	200	1235
4	300	100	350	100	1234
5	800	200	850	300
6
7
8	Date received	store code	amount	Total Amount received by date and store
9	1/1/2019	12355	500	1000
10	1/1/2019	12355	300	1000
11	1/1/2019	12355	200	1000
12	2/1/2019	12344	100	200
13	2/1/2019	12344	100	200
14	5/1/2019	12356	200	500
15	5/1/2019	12356	100	500
16	5/1/2019	12356	200	500
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5	1. / Formula is =A5<>SUMIFS($C$9:$C$16,$A$9:$A$16,">="&A$2,$A$9:$A$16,"<="&EOMONTH(A$2,0))	Abc

 

[Memar]

Thank you for your quick response. It works perfectly.How can I modify this formula when the dates should be exact the same?

Thanks again.

 

[AhoyNC]

What do you mean by "when the dates should be exact the same"?