Which is the correct option?

using the Thompson Industries' supplier file provided below, enter 55% into cell In that spreadsheet, any supplier should have its percentage returns in column H less than 50% and its on-time percentage in column G higher than 65%. Analytics manager Vicky Luo wishes to set up Conditional Formatting in Excel to identify any suppliers whose purchases do not meet any of those conditions What formula should go into the box Format values where this formula is true:? Click the icon to view the raw data for Thompson Industries' Suppliers. Choose the correct formula below o o = 0.46) More Info = 0.56) 2 5 10 12 13 14 15 16 17 18 19 20 8 c Thompson Industries Monthly Supplier Report - April Supplier Supplier Category SupplierName Maverick Supplies Cowboy Pete's Lumber ac Metals Perkins Plastics Everything Brass Jones Aluminum & Copper Ricks Wrought Iron Penelope's Paper Products nthony's Adhesives Columbus Manufacturing Smart Electronics. Inc. Watson Woodworking Fred's Foam Molding Inpenetrable Insulation, Inc. Suzy's Shipping Supplies D Total Purchases S38,778 S26,495 S28,079 S27,435 S30,075 S16,655 S29,875 S25,721 S22,675 S19,976 S30,666 S26,367 S28,192 S24,794 S24,448 print Change from Previous Quality On -time Percentage 100% 100% 100 100% 100% 100% Percentage Returns 12% 1% No. of Rejected Shipments 2 6 New Supplier Name 6071 6894 5054 5628 4413 5858 9733 4718 9944 1343 4785 2730 2949 1443 8039 Month Rating (1-5) S S S S SII,772 $1 ,972 S28,079 S31 ,687 (S3,583) S16,655 (S2,684) 276 (S' 286) (S3,661) S30,666 $8,619 S28,192 (S903) (S941) Done 5 3 4 5 4 3 4 4 5 Good 5 4