I want to change the color of fonts or cells by matching the date from a different workbook. I have a projection of sales in one workbook and actual sales in a different workbook. Whenever we get the actual total sold product types for the month, I want to deduct those form the projection workbook. Thus, I want to differentiate the by coloring the fonts or changing the color of the cell. Would you please help me how I can do this in Excel?
Data in the first workbook
Projected Sells by month
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1/31/2019[/TD]
[TD]2/28/2019[/TD]
[TD]3/31/2019[/TD]
[TD]4/30/2019[/TD]
[TD]5/31/2019[/TD]
[TD]6/30/2019[/TD]
[TD]7/31/2019[/TD]
[TD] TOTAL [/TD]
[/TR]
[TR]
[TD]Product A [/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
[TR]
[TD]Product D[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]2100[/TD]
[/TR]
[TR]
[TD]Product F[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]4200[/TD]
[/TR]
[TR]
[TD]ProductG [/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Data in the second workbook
Actual Sales
[TABLE="width: 500"]
<tbody>[TR]
[TD]Accounting date [/TD]
[TD]Product Type [/TD]
[TD]Amount Sold [/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product A [/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product B[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product C [/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product F[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product C[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product D[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product F[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product A [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product B[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product C[/TD]
[TD]500[/TD]
[/TR]
</tbody>[/TABLE]
DESIRED RESULT
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1/31/2019[/TD]
[TD]2/28/2019[/TD]
[TD]3/31/2019[/TD]
[TD]4/30/2019[/TD]
[TD]5/31/2019[/TD]
[TD]6/30/2019[/TD]
[TD] TOTAL [/TD]
[/TR]
[TR]
[TD]Product A [/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
[TR]
[TD]Product D[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]2100[/TD]
[/TR]
[TR]
[TD]Product F[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]4200[/TD]
[/TR]
[TR]
[TD]ProductG [/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]1400[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for your help and time.
Data in the first workbook
Projected Sells by month
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1/31/2019[/TD]
[TD]2/28/2019[/TD]
[TD]3/31/2019[/TD]
[TD]4/30/2019[/TD]
[TD]5/31/2019[/TD]
[TD]6/30/2019[/TD]
[TD]7/31/2019[/TD]
[TD] TOTAL [/TD]
[/TR]
[TR]
[TD]Product A [/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
[TR]
[TD]Product D[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]2100[/TD]
[/TR]
[TR]
[TD]Product F[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]4200[/TD]
[/TR]
[TR]
[TD]ProductG [/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Data in the second workbook
Actual Sales
[TABLE="width: 500"]
<tbody>[TR]
[TD]Accounting date [/TD]
[TD]Product Type [/TD]
[TD]Amount Sold [/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product A [/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product B[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product C [/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]1/31/2019[/TD]
[TD]Product F[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product C[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product D[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]2/28/2019[/TD]
[TD]Product F[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product A [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product B[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]3/31/2019[/TD]
[TD]Product C[/TD]
[TD]500[/TD]
[/TR]
</tbody>[/TABLE]
DESIRED RESULT
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1/31/2019[/TD]
[TD]2/28/2019[/TD]
[TD]3/31/2019[/TD]
[TD]4/30/2019[/TD]
[TD]5/31/2019[/TD]
[TD]6/30/2019[/TD]
[TD] TOTAL [/TD]
[/TR]
[TR]
[TD]Product A [/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
[TR]
[TD]Product D[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]300[/TD]
[TD]2100[/TD]
[/TR]
[TR]
[TD]Product F[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]600[/TD]
[TD]4200[/TD]
[/TR]
[TR]
[TD]ProductG [/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]1400[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for your help and time.