PROVIDE ALL STEPS/FORMULAS NEED TO SOLVE REQUIREMENT 1

TID Date Status 215087 215088 42009 Paid 215089 42013 Paid 215090 42017 Open 215091 42021 Credit 215092 42192 Paid 215093 42029 Paid 215094 42033 Open CustID RAM101 DIG290 HBC160 EIN405 QCM550 QEX711 SAT017 NEW011 Amount 8980 6440 4082 7320 7300 4800 5650 5420 Required 1: Apply a conditional formatting rule that will highlight the table row for each order that is open and greater than 7000