I have a workbook in which sheet 1 contains employee assignments for the
upcoming week.

Sheet 2 contains several dynamic named ranges. I have one for each project
manager in the firm with a list of the projects currently assigned to them.

I want to create conditional formatting rules to change the cells on sheet 1
if data is contained in one of the named ranges.