Open the ColorScalesAndIconSets workbook from the Student Data Files$$

Excel $2019$ folder.

$2.$ On the Documentation sheet, type your name in B$4$ and the current date in

B$5.$

$3.$ On the Color Scales And Icon Sets sheet, use Conditional Formatting to

apply a Green $$ White Color Scale to B$7$:E$15.$

$4.$ On the Color Scales And Icon Sets sheet, use Conditional Formatting to

apply a White $-$ Red Color Scale to B$23$:E$31.$

$5.$ Edit the White $-$ Red Color Scale on B$23$:E$31$ so the Lowest Value is white

and the Highest Value is Dark Red in the Standard Colors.

$6.$ On the Color Scales And Icon Sets sheet, use Conditional Formatting to put a

$3$ Arrows $($Colored$)$ Icon Set onto G$7$:I$15.$

$7.$ On the Color Scales And Icon Sets sheet, use Conditional Formatting to put a

$3$ Triangles Icon Set onto G$23$:I$31.$

$8.$ Edit the $3$ Arrows $($Colored$)$ Icon Set on G$7$:I$15$ so that:

a$.$ When the number is greater than or equal to $2000,$ it displays a green

up arrow.

b$.$ When the number is zero, it displays no icon; $($Hint: No Cell Icon is in

the drop$-$down Icon list.$)$

c$.$ When the number is less than zero, it displays a red down arrow.

$9.$ Edit the $3$ Triangles Icon Set so that:

a$.$ When the percent is greater than or equal to $75\%,$ it displays a green

upward pointing triangle.

b$.$ When the percent is less than $75\%$ and greater than or equal to $25\%,$

it displays a hollow white circle $.$

c$.$ When the percent is less than $25\%,$ it displays a red downward

pointing triangle.

$10.$ Change the printing orientation to Landscape.

$11.$ Set a left print header of your first and last name.

$12.$ Set a right print header of the code for the sheet name.

$13.$ Set a center footer of the page number.

$14.$ Type your first and last name in A$3.$ Then set the font color to white.

$15.$ Select K$1.$

$16.$ Save and submit the workbook by the deadline.