Forum Discussion
Mkolpek
Oct 16, 2021Copper Contributor
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!
- Oct 17, 2021
Mkolpek Like so? See attached.
Juliano-Petrukio
Oct 16, 2021Bronze Contributor
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.
- MkolpekOct 17, 2021Copper Contributor
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!
- Riny_van_EekelenOct 17, 2021Platinum Contributor
Mkolpek Perhaps the examples in the attached workbook will be helpful.
- BellaP1255Aug 16, 2024Copper ContributorHi Riny_van_Eekelen I am trying to do the same thing and I downloaded the sample but I am not seeing what was done. Please can you explain or provide the steps. Thank you