Excel - How to shade a cell in a table, once it's been copied and pasted.

Mkolpek Understood. The screenshot doesn't show and cell reference, so it will be difficult to give you the correct rule for conditional formatting for your workbook. So, upload the file without any confidential information or try to replicate the second example from the file I uploaded. List 1 would then be equivalent to the list with all employees. List 2 contains the names you copied to the schedule on the left.