1. Conditional Formatting Assessment

Twitch is a livestreaming video service. While you can find a variety of different types of content on Twitch, they are primarily known for video game streaming. Top streamers can earn millions of dollars a year.

The Value, Top, and Symbols worksheets all contain data on the top 200 Twitch gaming streamers in 2020. On the Value worksheet, use conditional formatting based on target values to examine the data. Use conditional formatting based on exceptional values to analyze the data on the Top worksheet. Finally, use the Data Bars, Color Scales, and Icon Sets to examine the data on the Symbols worksheet. (my email [email protected])

1.1

Use conditional formatting to highlight the number of followers for streamers with more than 500000 followers.

a. Apply the conditional formatting to range G3:G202.

b. Highlight values over 500000 with light green background and dark green text.

1.2

Use conditional formatting to highlight the number of streaming minutes for streamers with less than 100000 minutes streamed.

a. Apply the conditional formatting to range D3:D202.

b. Highlight values less than 100000 minutes streamed with light red background and dark red text.

1.3

Use conditional formatting to highlight the value for average viewers of streamers with between 5000 and 8000 average viewers.

a. Apply the conditional formatting to range F3:F202.

b. Highlight values between 5000 and 8000 average viewers with light yellow background and dark yellow text.

1.4

Use conditional formatting to highlight the value for language of streamers who speak Czech.

a. Apply the conditional formatting to range H3:H202.

b. Highlight values that contain the text "Czech" (without the quotes) with light red background and dark red text.

1.5

Use conditional formatting to highlight the top 30 values for minutes of watch time.

a. Apply the conditional formatting to range C3:C202.

b. Highlight the top 30 values for watch time with light green background and dark green text.

1.6

Use conditional formatting to highlight the bottom 15 % of values for minutes of stream time.

a. Apply the conditional formatting to range D3:D202.

b. Highlight the bottom 15% of values for stream time with light red background and dark red text.

1.7

Use conditional formatting to highlight the above average values for peak viewers.

a. Apply the conditional formatting to range E3:E202.

b. Highlight the above average values for peak viewers with light yellow background and dark yellow text.

1.8

Use Data Bars to highlight the number of peak users for each streamer.

a. Apply the conditional formatting to range E3:E202.

b. Select the blue data bars option.

1.9

Use Color Scales to highlight the number of followers for each streamer.

a. Apply the conditional formatting to range G3:G202.

b. Select a three-color option.

1.10

Use Icon Sets to highlight the number of minutes streaming for each streamer.

a. Apply the conditional formatting to range D3:D202.

b. Use the 3 Arrows (Colored) option.