4. the administrator overseeing the cancer center is considering mandating that all inpatient service names be different from outpatient service names, and wants to see which duplicate names are currently in use. apply a conditional formatting rule to the range c4:c11 that uses light red fill with dark red text for duplicate values.