Conditional formating homework

Insert Page Layout Formulas Data Review ViewTell me what you want to do General Normal E Copy B l u. |A Merge & Certer. $. % , '68.8 Conditional Format as Check Cell Explanatory Format Painter Formatting Table Clipboard Alignment Number Toys "R" US Toys "R" US 5 Instructions Year Quarter Sales Year Quarter Sales 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 1555 1738 1883 4868 1924 1989 2142 4383 2043 2020 2171 4338 2186 1555 1738 1883 4868 1924 1989 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 8 9 10 11 1. Highlight in RED all quarters for which revenue has increased over at least the last two quarters 2. Use a Color Scale to identify the Years 141. Highlight all fourth-quarter revenues in 15 BLUE and first -quarter revenues in RED 16 2. Use a Color Scale to identify the Years 4383 2043 2020 4338 2186 2204 2465 5027 2319 1994 2220 4799 2061 2021 2465 5027 2319 1994 2220 4799 2061 2021 1 23 1