Please explain using excel screenshot and formulas, thank you

AutoSave Off A v ACCT 307 - Spring 2020 - DA Project 2 -- updates as of 03.13 - Search File Home Insert Page Layout Formulas Data Review View Developer Help Cut EX E Auto: Insert Delete Format Fill Clear Cells Calibri 11 A A === Or ag Wrap Text General [Copy v Paste Conditional Format as Cell BIU - B A - 3 Merge & Center - $ - % , Format Painter Formatting Table Styles Clipboard Font To Alignment Number Styles R9 : x V for 2 A B C D E F G H I J K Use conditional formatting to highlight values in the data below that individually meet the four criteria entered into the blue cells. Each of the cells B5, C5,D5, and E5 should have a separate conditional formatting rule. 3 Date Product Region SalesRep Customer Sales COGS Product Product3 5 4/25/2020 Product3 Region3 SalesRep2 Customer16 $ 14,046 $ 5,337 Region Region3 SalesRep SalesRep2 Customer Customer16 L M N 1 28 29 - ... Worksheet 1 Worksheet 2 Worksheet 3 Worksheet 4 Worksheet 5 Worksheet 6 Worksheet 7 Worksheet 8 Worksheet 9 Worksheet 10 Worksheet 11