1. The conditional formatting rule in column G highlights cells that contain the value 5, the highest evaluation rating. Padma wants to change the highlighting to use colors that are associated with positive values. Edit the conditional formatting Highlight Cells Rule for the range G5:G52 to highlight the cells containing values equal to 5 with a font color of Teal, Accent 2, Darker 50% (6th column, 6th row in the Theme Colors palette) and a fill color of Teal, Accent 2, Lighter 60% (6th column, 3rd row in the Theme Colors palette).
2. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2022, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell H5. Clear the conditional formatting rule from the range H5:H52 if Excel applies it.

Veritate Online Contractor List Pay Categor 1 Eval Ratin- 5 2 4 2 2 4 2 1 5 5 1 1 5 1 5 1 5 Start Year - 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2020 3 3 1 ID - First - Last Specialty c3571 Kirstin Bohner Clothing and shoes c4412 Marguerite Cortez Garden and home c3049 Ruth Dudusola Electronics c8031 Reid Greene Movies and music c4573 Pete Hamadache Movies and music c1922 Rusty Lawson Automotive c2489 Bert Leonard Electronics c2463 Rashad Mahala Garden and home c2326 Vashti Popoola Sports and outdoors c9453 Bobby Rodgers Electronics c4986 Elicia Settles Garden and home c7972 Nikita Amiri Automotive c5228 Laverne Custer Movies and music c9808 Marilyn Frazier Garden and home c4865 My Van Garden and home c7469 Howard Agbaje Electronics c4317 Anita Melander Electronics c5847 Anne Moussa Automotive c1885 Victorina Cobblewick Clothing and shoes c5486 Maria Conner Garden and home 09888 Louise Diallo Sports and outdoors c7466 Donnie Grazia Electronics 08508 Hannah Johnson Movies and music Documentation Contractors 5 2 4 1 5 1 5 2 4 4 2. 1 5 1 5 2 4 5 1 3 3 2020 2020 2020 2020 4 2. 2. 4 H Eval Rating 5 3 4 3 . 5 4. 4 4 B 3 4 3 3 4 st ID First Last 28 c1438 Lenard Kalende 29 08597 Joanna Munisi 30 c5261 Jarvis Ransom 31 c5455 Long Sow 32 c5117 Shantelle Washington 33 c2158 Craig Waters 34 c6406 Gregg Watts 35 c3217 Jarod Whetstone 36 c2525 Luna Zimmerman 37 06541 Hunter Baker 38 c7075 Bradley Bowers 39 c3923 Blake Collins 40 c3948 Nancy Dereda 41 c6771 Carin Hall 42 c6071 Melissa Jensen 43 c5356 Eun Johns 44 04614 William Miller 45 C8686 Everett Murray 46 c6664 Susan Olson 47 c6084 | Phc Trang 48 c4866 Jack Westerman 49 c4218 Nhung Hong 50 c1722 Thanh Hue 51 07251 TFernanda Ng 52 c5496 Mai Young - Specialty Start Year Movies and music Movies and music Sports and outdoors Clothing and shoes Movies and music Electronics Movies and music Automotive Garden and home Automotive Sports and outdoors Movies and music Sports and outdoors Sports and outdoors Sports and outdoors Automotive Automotive Clothing and shoes Clothing and shoes Automotive Electronics Clothing and shoes Movies and music Clothing and shoes Garden and home - Pay Category 2020 1 2020 3 2020 2 2020 1 2020 2 2020 2. 2020 2. 2020 3 2020 2 2021 3 2021 3 2021 2 2021 2 2021 2 2021 3 2021 3 2021 1 2021 2 2021 2 2021 3 2021 1 2022 1 2022 2 2022 3 2022 1 4 N N 4 3 3 NEW 5 4 4 3 5 5 4 3 w w 3 Start Year H - Pay Category 2022 1 Eval Rating 3 ID First Last - Specialty 52 c5496 Mai Young Garden and home 53 54 Product Specialty Category 55 Automotive 1 56 Clothing and shoes 57 Electronics 3 58 Garden and home 2 59 Movies and music 2 60 Sports and outdoors 3 61 4 Nm nm Min per Post $50 $100 $200 $100 $125 $150