Using the raw data for Thompson Industries' Suppliers provided below, analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to determine 5 suppliers with the largest total purchases values in column D. Which Conditional Formatting 'Rule Type' should she select? PER Click the icon to view the raw data for Thompson Industries' Suppliers. Choose the correct answer below. O "Format only cells that contain" "Format all cells based on their values" "Format only unique or duplicate values" "Format only top or bottom ranked values" O 1 Thompson Industries Monthly Supplier Report - April No. of Percentage Rejected Returns Shipments New Supplier (YN) 0% Quality On-time Rating (1-5) Percentage 100% 90% 0% 100% 100.0% Total Purchases $39,813 $25,523 $32,537 $28,920 $30,059 $16,861 $28,236 $26,313 75% 3% 5 SupplierName 6 Maverick Supplies 7 Cowboy Pete's Lumber 8 ABC Metals 9 Perkins Plastics 10 Everything Brass 11 Jones Aluminum & Copper 12 Rick's Wrought Iron 13 Penelope's Paper Products 14 Anthony's Adhesives 15 Columbus Manufacturing 16 Smart Electronics, Inc. 17 Watson Woodworking 18 Fred's Foam Molding 19 Inpenetrable Insulation, Inc. 20 Suzy's Shipping Supplies Supplier Supplier Category Name (P.S) 6071 6894 5054 5528 4413 5858 9733 4718 9944 1343 4785 2730 2949 1443 8039 50% Change from Previous Month $31,742 $376 $32,537 $38,186 ($3,671) $16,861 ($2,081) $9.430 ($7,999) $10,214 $31,983 $594 $17.424 ($258) $143 w 8$ $23,256 90% co OOOOOOOOOO Good $19,568 $31.983 $24,416 $17,424 $24,567 $24,284 5