please show me how to do it in excel step by step

Question 3 [16 marks] Grossflix, a streaming service as well as production company gathered data on several longstanding programs in the US in order to develop a new series. The data is shown in "Question 3 tab of the answer sheet. Help the managers draw conclusion from the data by performing the following: a. Highlight the network channels (Column B) with different colors. Provide description of the colors. [4 marks] b. Assign icons to differentiate show ratings (Column C) between 1-30, 31-65 and 66-100. Provide description of the icons. [6 marks] C. Highlight in green the programs (Column A) with ratings above 50 and in red programs with ratings below 10. [6 marks] B D E F Ratings 35 74 82 23 98 77 44 47 13 62 71 26 80 71 17 32 9 18 74 85 82 40 27 1 Program 2 20/20 3 30 Rock 4 48 Hours Mystery (Sat 10:00 pm) 5 48 Hours Mystery (Sat 9:00 pm) 6 48 Hours Mystery (Tues 10:00 pm) 7 60 Minutes 8 According to Jim (Tues 8:00 pm) 9 According to Jim (Tues 8:30 pm) 10 American Dad (Sun 7:30 pm) 11 American Dad (Sun 9:30 pm) 12 American Idol (Tues 8:00 pm) 13 American Idol (Wed 9:00 pm) 14 America's Funniest Home Videos ?? 15 America's Most Wanted 16 Are You Smarter than a 5th Grader? 17 Bachelor 18 Back to You 19 The Big Bang Theory 20 Big Brother (Sun 8:00 pm) 21 Big Brother (Tues 9:00 pm) 22 Big Brother (Wed 8:00 pm) 23 Biggest Loser 24 Bones 25 Boston Legal 26 Brothers & Sisters 27 Canterbury's Law 28 Cops (Sat 8:00 pm) 29 Cops (Sat 8:30 pm) 30 Crimetime 31 Criminal Minds 32 CSI 33 CSI: Miami 34 CSI: NY 35 Dancing with the Stars 36 Dancing With the Stars (Tues 9:00 pm) 37 Dateline (Fri 9:00 pm) 38 Dateline (Sun 7:00 pm) 39 Deal or No Deal (Mon 8:00 pm) 10 Deal or No Deal (Wed 8:00 pm) 11 Democratic Presidential Debate 42 Desperate Housewives (Fri 8:00 pm) 13 Desperate Housewives (Sun 9:00 pm) 74 Don't Forget the Lyrics! 75 Duel 46 Eli Stone 47 ER 48 Family Guy Network ABC NBC CBS CBS CBS CBS ABC ABC FOX FOX FOX FOX ABC FOX FOX ABC FOX CBS CBS CBS CBS NBC FOX ABC ABC FOX FOX FOX CBS CBS CBS CBS CBS ABC ABC NBC NBC NBC NBC ABC ABC ABC FOX ABC ABC NBC FOX 86 89 12 66 14 24 35 73 84 59 85 93 24 37 31 69 84 60 67 17 82 98 78 60