Is there a macro that would allow me to link the fill color of each cell in the Sheet 2 matrix (range D4:K13) to the corresponding cells in the Sheet 1 matrix (range D4:K13)? I want to bring in the fill color but not the text. The 'Manual' worksheet shows what I would like the Sheet 2 matrix to look like.
Any thoughts?
An initial fill would look like this, but are you saying you then also want the colors on sheet 2 to change any time you change a color on sheet 1?
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Yes, I would like for the colors to update as the changes are made to the workbook. This seems to work for the initial fill but the macro has to be run again if changes are made
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks