Adjust value of a cell based on the formatting of another using VBA

[Mr2017]

Hi

Simple question about VBA.

I have two sheets - Sheet 1 and Sheet 2.

Sheet 1 has the values 1, 2, and 3 in cells A1, A2, and A3, respectively.

Sheet 1 also has the values 4, 5, and 6 in cells B1, B2, and B3, respectively.

Cells A1 and B3 in Sheet 1 are highlighted in yellow. So Sheet 1 looks like this:

1​	4​
2​	5​
3​	6​

Sheet 2 has the number 0 in cells A1, A2, A3, B1, B2, and B3. Like this:

0​	0​
0​	0​
0​	0​

Question:

Is it possible to get VBA to adjust the values of cells in Sheet 2 based ONLY on the values of the HIGHLIGHTED cells in Sheet 1?

ie the values in the cells in Sheet 2 would become 1 in cell A1 and 6 in cell B3, because those cells are highlighted yellow in Sheet 1? And the formatting would also change so that the cells that have changed in Sheet 2 also become yellow?

Please let me know if you'd like me to clarify the question.

Thanks

 

[Peter_SSs]

Thanks Peter!!

Both the fixed and dynamic versions worked!

Thanks again for your help!

You're welcome. Thanks for the confirmation.

 

[Mr2017]

You're welcome. Thanks for the confirmation.

No problem!