A D E F Tenure based Commission J K N Total Goal based Commission Goal Actual Commission Rep Hire Date Sales Reps receive commissions based on whether or not they reach their sales goals. If reps achieve their goal they receive a 7% commission. If they do not, they receive a 4% Smith 1/2/2008 $ 200,000 $ 182,000 Jones Frye Tucker Cattel Holland 6/18/2009 $ 2/5/2015 $ 165,000 $ 190,000 11/4/2017 $ 220,000 $ 205,000 commission. 200,000$ 200,000 12/4/2005 Additionally sales reps will receive a bonus commission of 2% if they have been employed for 10 years (regardless of whether goal is met.) 190,000 3/2/2007 $ 180,000 176,000 $ 180,000 Please calculate total commissions for each sales rep. Conditionally format all Sales reps that receive more than $12,000 commission. FORMAT ENTIRE ROW in yellow fill