Excel - How to shade a cell in a table, once it's been copied and pasted.
I'm wanting to shade cells in a table once they've been copied and pasted to another location in the same sheet. Thanks!
Mkolpek Like so? See attached.
Forum Discussion
Riny_van_Eekelen I wasn't able to figure out how to apply that to my application. Here is what I'm trying to do...I have the Employees on the right...and I copy / paste their names into the schedule on the left (which I'm showing just a small portion of). When I paste them...I would like their name to change somehow either by font or cell color...in the employee name column. Thanks!
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.
Riny_van_Eekelen The Z column is where I want to see the name change font or cell color. thanks!
Mkolpek Like so? See attached.
- Yes...that's it exactly. What did you do?