Using made up data, use conditional formatting in the following situations:

-Format in bold each month in which the value of the S&P(make it up) index increased, and underline each month in which the value of the S&P index decreased.

-Highlight in green each month in which the S&P index changed by a maximum of 2 percent.

-Highlight the largest S&P index value in red and the smallest in purple.

Using made up data, highlight in red all quarters for which revenue has increased over at least the last two quarters. Highlight all fourth-quarter revenues in blue and first-quarter revenues in red.

USE EXCEL