In cells B17 - E28, Ken wants the dealerships quarterly cells that are >= the quarterly expected volume cells to be formatted as with the font color as White and the fill color as Green. You must use conditional formatting to accomplish this as demonstrated on pages 304-311 of the book... specifically the part on "Use Formulas in Conditional Formatting" on 310. So for this assignment, since cell C17 (dealer # 3254's 2nd quarter sales) has a value of 468 and since that volume is greater than the 2nd quarter Expected Volume in cell D4 it should turn green. That dealer's 1st quarter sales in cell B17 should NOT automatically turn green since 356 is less than the 1st quarter's expected volume of 359 located in cell C4. How I did it: Click on B17, create the new rule making sure that I use a formula that utilizes referencing in such a way that I can use the format painting tool to copy the conditional formatting across and down throughout cells B17:E28 and still have the formulas compare these cells in B17:E28 to cells C4:F4. Hint: Get the conditional formatting working for cell B17. The formula used for this conditional formatting should compare B17 to C4. If you get the referencing correct in this formula you will be able to use the format painter to copy it across and down to the entire B17 - E28 range of cells. Green is the 6th color from the left when you get to the Fill tab. Don't forget to also set the Font color to White!

617 G H I J K L M N O P Q R SL C D E Manufacturer Rebates to Dealers 10 20 30 Shipping Rebate: $84 $97 $88 Expected volume: 369 464 477 40 Annual $141 n/a 385 7.40% 8,450 2.50% 6 Additional Inputs: Overall Sales volume bonus 7 equal to or over 7.4% Overall Sales volume bonus if 8 >=2.5 and =2.5 and