Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting. In the same worksheet in part (c) dynamically apply the following...

Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting.

In the same worksheet in part (c) dynamically apply the following formats for Qtr1
and Qtr4 for all related revenue types:
i. Values over $140,000 should be yellow. [2]
ii. Values under or equals to $80,000 should be read and bolded