Each row is a record of contracts signed that day stating the number of rolls and profit/roll of that contract. Complete the following:

1. Create a new column calculating the total profit per contract. Apply conditional formatting to this column to visually demonstrate the range of profits/contract.

Please provide formulas used, and in which cell they were applied to along with other potent information USING EXCEL. Thank you.

DATA BELOW

DateE25G1A1:EA1:E42	Employee	Rolls Contracted	Profit/Roll	Total Profit Per Contract
8/1/2014	Patrick	73,000	$ 14.37	$ 14.37
8/2/2014	Julie	66,000	$ 6.32	$ 6.32
8/2/2014	Julie	3,000	$ 12.78	$ 12.78
8/2/2014	Julie	28,000	$ 13.50	$ 13.50
8/3/2014	Anne	42,000	$ 9.21	$ 9.21
8/4/2014	Anne	32,000	$ 12.85	$ 12.85
8/4/2014	Patrick	69,000	$ 11.12	$ 11.12
8/4/2014	Anne	55,000	$ 11.49	$ 11.49
8/5/2014	Julie	59,000	$ 10.48	$ 10.48
8/5/2014	Anne	18,000	$ 14.16	$ 14.16
8/5/2014	Julie	39,000	$ 14.62	$ 14.62
8/6/2014	Anne	24,000	$ 12.49	$ 12.49
8/6/2014	Julie	35,000	$ 11.35	$ 11.35