Question

Please help, i am using office 360. Thank you!

G H 1 J 3 4 LO 7 ar А. B C с D E F H 1 SG&A Variance to Forecast 2 3 Deptid Department Actual Forecast Variance 4 100 Corporate $187,274 $175,000 -7.01% 5 101 Accounting $61,456 $60,000 -2.43% 6 102 HR $88,133 $90,000 2.07% 200 Operations $167,209 $150,000 -11.47% 8 202 Research $116,801 $125,000 6.56% 9 206 Manufacturing $175,202 $165,000 -6.18% 10 301 Sales $169,975 $125,000 -35.98% 11 305 Marketing $212,012 $185,000 -14.60% 12 400 Logistics $172,371 $200,000 13.81% 13 410 IT $92,749 $100,000 7.25% 14 420 Warehouse $57,845 $75,000 22.87% 15 16 Required: 1. Highlight all variances greater than +10% with Green Fill with Dark Green Text. 17 2. Highlight all variances less than -10% with Ligh Red Fill with Dark Red Text. 18 9 1

Answer 1

Table-1

1)

DeptID	Department	Actaul	Forecast	Variance
100	Coporate	$187,274	$175,000	-7.01%
101	Accounting	$61,456	$60,000	-2.43%
102	HR	$88,133	$90,000	2.07%
200	Operations	$167,209	$150,000	-11.47%
202	Research	$116,801	$125,000	6.56%
206	Manufacturing	$175,202	$165,000	-6.18%
301	Sales	$169,975	$125,000	-35.98%
305	Marketing	$212,012	$185,000	-14.60%
400	Logistics	$172,371	$200,000	13.81%
410	IT	$92,749	$100,000	7.25%
420	Warehouse	$57,845	$75,000	22.87%

2)

DeptID	Department	Actaul	Forecast	Variance
100	Coporate	$187,274	$175,000	-7.01%
101	Accounting	$61,456	$60,000	-2.43%
102	HR	$88,133	$90,000	2.07%
200	Operations	$167,209	$150,000	-11.47%
202	Research	$116,801	$125,000	6.56%
206	Manufacturing	$175,202	$165,000	-6.18%
301	Sales	$169,975	$125,000	-35.98%
305	Marketing	$212,012	$185,000	-14.60%
400	Logistics	$172,371	$200,000	13.81%
410	IT	$92,749	$100,000	7.25%
420	Warehouse	$57,845	$75,000	22.87%

Table-2

1)

Summary
	Total Debits	$25,853
	Total Credits	$25,853
		$0.00

2) Difference Value is equal to $0.00, so no color will apply even using formula and will be seen as plain table as per following:

Summary
	Total Debits	$25,853
	Total Credits	$25,853
		$0.00