Reason2Go Advertising Expenses
Type	Inv. Date	Inv. Due	Cost ea.	Quantity	Ext. Cost	Sales Tax	Total		% of Total
USB drive	1/1/17	1/31/17	5.34	5	26.7	2.60325	29.30325		0.000504
TV Sponsor	1/7/17	2/8/17	250	15	3750	365.625	4115.625		0.070853
Podacsts	1/20/17	2/19/17	77.5	30	2325	226.6875	2551.688		0.043929
TV Commercials	1/1/17	1/31/17	1054.42	4	4217.68	411.2238	4628.904		0.079689
Web page asd	1/13/17	2/12/17	0.17	230	39.1	3.81225	42.91225		0.000739
Magazine	1/7/17	2/6/17	100.92	12	1211.04	118.0764	1329.116		0.022882
Pens	1/5/17	2/4/17	0.12	250	30	2.925	32.925		0.000567
TV Sponsor	1/15/17	2/14/17	250	15	3750	365.625	4115.625		0.070853
Billboard	1/12/17	2/11/17	101.87	20	2037.4	198.6465	2236.047		0.038495
USB drive	1/25/17	2/24/17	5.34	6	32.04	3.1239	35.1639		0.000605
USB drive	2/1/17	3/3/17	5.34	2	10.68	1.0413	11.7213		0.000202
T-shirts	2/3/17	3/5/17	5.67	200	1134	110.565	1244.565		0.021426
TV Commercials	2/1/17	3/3/17	1054.42	4	4217.68	411.2238	4628.904		0.079689
USB drive	3/1/17	3/31/17	23.91	2	47.82	4.66245	52.48245		0.000904
Web page asd	2/28/17	3/30/17	0.17	275	46.75	4.558125	51.30813		0.000883
Magazine	2/27/17	3/29/17	100.92	12	1211.04	118.0764	1329.116		0.022882
Podacsts	2/22/17	3/24/17	77.5	30	2325	226.6875	2551.688		0.043929
TV Sponsor	2/1/17	3/3/17	250	30	7500	731.25	8231.25		0.141706
USB drive	2/25/17	3/27/17	5.34	6	32.04	3.1239	35.1639		0.000605
Web page asd	3/10/17	4/9/17	0.17	275	46.75	4.558125	51.30813		0.000883
TV Sponsor	2/15/17	3/17/17	250	25	6250	609.375	6859.375		0.118088
Pens	3/15/17	4/14/17	0.12	250	30	2.925	32.925		0.000567
TV Commercials	3/1/17	3/31/17	1054.44	4	4217.76	411.2316	4628.992		0.079691
Hats	3/20/17	4/19/17	7.2	250	1800	175.5	1975.5		0.034009
Podacsts	3/20/17	4/19/17	75.5	30	2265	220.8375	2485.838		0.042795
USB drive	3/21/17	4/20/17	5.34	2	10.68	1.0413	11.7213		0.000202
Podacsts	3/23/17	4/22/17	77.5	30	2325	226.6875	2551.688		0.043929
Billboard	3/28/17	4/27/17	101.87	20	2037.4	198.6465	2236.047		0.038495
			4941.09	2034	52926.56	5160.34	58086.9	0	1

2. Applying Accounting number format to range D4:D32 (dollar sign and two decimal places)

3. Add comma (,) in range F4:H32

4. In range J4:J32, change the number format to % with one decimal place

5. In range B4:B31, change the date format to 14-Mar-12 format (select the range, right click and choose Format Cells select the Number tab select Date in the Category box & choose the desired date format in the Type box.

6. In range C4:C31, change the date format to 14-Mar (no year) format

7. In range J1:K1, apply neutral cell style (using Cell Styles button under the Home tab,

8. In range H4:H30, use Conditional Formatting to apply a green data bar in each cell

a. Click Home tab, click Conditional Formatting button Data Bars Green Data Bar

9. In range F4:F30, use Conditional Formatting to highlight those cells whose value is between 2000 and 4000 in light red color

a. Conditional Formatting button Highlight Cell Rules Between change numbers to 2000 and 4000 Light Red Fill