1. Dean Hilson is the director of Camp Bright Firewood. He started planning the camp staffing assignments for next year in an Excel table, and needs your help completing the table. First, hed like to confirm that all the staff data was entered correctly into the worksheet. Go to the Staff Listing worksheet and complete the following steps:

a. Apply a conditional formatting Highlight Cells Rule to the range A2:A31 that formats any duplicate values with Light Red Fill with Dark Red Text.

b. Correct the duplicate values by updating the Staff ID for Artie Jimenez to 1055 and the Staff ID for Sylvia Lee to 1087. (Hint: When this sub-step is completed, the conditional formatting rule should no longer highlight any values in the range.)