Help excel

All the following instructions are to be carried out in the Performance worksheet. 1. a) Select B5:G11 and apply a Data Bar conditional format. b) Change the color of the data bars to grey. 2. a) Select B13:G13 and apply a Green-Yellow Color Scale conditional format. b) Apply the Format Painter to copy the conditional formatting to B26:G26. 3. a) Select B31:H37 and apply a traffic light icon conditional format. b) Modify the format so that values >=90% get a green light, >=80% get an amber and everything else is red 4. a) Select H5:H11 and apply a conditional format to highlight the top two values. b) Select H18:H24 and apply a conditional format to highlight values greater than 1. 5. Select A18:H24 and add a conditional formatting rule to fill the whole row with medium blue where the salesperson name matches the selection in cell L3. 6. Select B18:G24 and apply a conditional formatting rule that highlights all the cells between the values shown in F16 and G16 in red. 7. In cells L4, L5 and L6, use the lookup function of your choice to lookup the total sales, average actual/target ratio and average customer satisfaction rate for the selected salesperson in cell L3. 8. In cell L3, create a drop-down list of the names of seven salespeople.