Hi!
So I'm trying to figure out a way to copy cell interior colors from one worksheet to another.
Let's say I have an excel with 3 sheets: Worksheet 1 = WS1 and Worksheet 2 = WS2 and Worksheet 3 = WS3
These three worksheets are just basically copies of the first one.
So, if I have cell F4 in WS1 that I fill in as yellow, I want the cell F4 to be painted as yellow also in WS2 and WS3.
AND if I choose to change the cell color of F4 in WS1 from yellow to e.g. blue, I want that to also change the cell color of F4 in WS2 and WS3.
I am working with max. of five different colors, so not all colors need to be included.
The values in the cells don't matter, I just want to copy the interior color.
Question is: Is this possible and how would I go about it? I have very little experience in VBA...
So I'm trying to figure out a way to copy cell interior colors from one worksheet to another.
Let's say I have an excel with 3 sheets: Worksheet 1 = WS1 and Worksheet 2 = WS2 and Worksheet 3 = WS3
These three worksheets are just basically copies of the first one.
So, if I have cell F4 in WS1 that I fill in as yellow, I want the cell F4 to be painted as yellow also in WS2 and WS3.
AND if I choose to change the cell color of F4 in WS1 from yellow to e.g. blue, I want that to also change the cell color of F4 in WS2 and WS3.
I am working with max. of five different colors, so not all colors need to be included.
The values in the cells don't matter, I just want to copy the interior color.
Question is: Is this possible and how would I go about it? I have very little experience in VBA...