solve questions using highlight function and excel formulas

Question The worksheet 'Data' contains quarterly revenues for a firm. Use conditional formatting (cell fill color) to: 1. Highlight the revenues for the 4th quarter using a shade of blue. The revenue figures should be visible/readable after highlighting. ( 5 points) 2. Highlight the year (not the revenue) in which the revenue is above average using a shade of green. The years should be visible/readable after highlighting. (5 points)