Copy Fill color in another worksheet...
I have lots of worksheets and one summary page at the end... Each worksheet has a line with different fill color in the cells.
I want to copy the fill color that I have in these cell (of say page 1) into my summary page (and if it is changed in page 1, the fill color will automatically be also changed in my summary...).
How can I do that?
Thanks so much!
why cant u go for format painter
why cant u go for format painter?
When I use the format painter, it does the job the first time, but if I change the fill color, it doesn't automatically change it on the target worksheet...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1