Forum Discussion
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.
10 Replies
Usually if your original table is already shaded you can check if it was "shaded" by conditional formatting or manually shaded. If it is based on conditional formatting, you need to adjust the logic behind so it can be dynamical when you paste everything to another place.
Well, you need to give us more details about your copy and paste action. Data only, data with formats, only formats, etc.
Because we can, lets say, "prepare the terrain" where your data will be pasted with some conditional formatting logic. But you need to give us the details mentioned before.
Thanks for your reply. I'm trying to populate a schedule. I have a list of names in column...I copy and paste them into the schedule. I would like to see which names I copied so I can keep track of who is left without having to keep double checking to match names copied to names still on the list.
I've used a similar schedule in the past and when I pasted a name into the schedule...the cell where the list of names is would change the font color of the name after being pasted somewhere else in the same sheet. Hope that helps..thanks!
Mkolpek Perhaps the examples in the attached workbook will be helpful.
