Copy colored cell to other cells within the same sheet

[roseannej78]

I have a colored cell (B13) with some text only and another different colored cell (B14) with some text only. I want other cells (D5, E5, & F5) within the same sheet to automatically have the same color from cell B13 but not copy text, just copy the color. I want this repeating with other cells (D6, E6, & F6) but with the color in cell B14. How do I do this? Thanks in adavance!!

[HaHoBe]

Hi, roseannej78,

the change of a background colour doesn´t raise any event in Excel that could be used to paste the colour only. Do you have formulas in the cells to monitor or plain values? If you enter the valiues manually you could use this code (behind the sheet you want to monitor, right click on woirksheet-tab, choose View Code and paste into Code Window):

Please Login or Register  to view this content.

Please mind that this code will not pick up the colour chosen by use of Conditional Formatting.

Ciao,
Holger

[roseannej78]

Hi, roseannej78,

the change of a background colour doesn´t raise any event in Excel that could be used to paste the colour only. Do you have formulas in the cells to monitor or plain values? If you enter the valiues manually you could use this code (behind the sheet you want to monitor, right click on woirksheet-tab, choose View Code and paste into Code Window):

Please Login or Register  to view this content.

Please mind that this code will not pick up the colour chosen by use of Conditional Formatting.

Ciao,
Holger

Hello Holger,

Thank you for your quick response! The codes work great! This is what I wanted, however (this is all my fault) I mentioned the wrong cells that I wanted to color. I put cells D5, E5, & F5. I meant to put every other cells D5, F5, & H5. I know there is probably just a minor change to your codes, but I don't know what to change/add. Thanks for your time & patience!

[HaHoBe]

Hi, roseannej78,

like you mentioned: not a big deal. You could help yourself recording a macro to get the information you need and add it accordingly to the code or copy this bit of code

Please Login or Register  to view this content.

Please do not quote full posts but only the necessary parts of these if needed.

Ciao,
Holger

[roseannej78]

This is perfect!! Thanks again for your help!!!!

[HaHoBe]

Hi, roseannej78,

thanks for the feedback - here´s another way to solve:

Please Login or Register  to view this content.

Ciao,
Holger

[roseannej78]

Hi Holger

WorkSchedule.xlsm

I hope you can open the attachment.

When I was using your code, I entered it in a new sheet and it worked perfectly. I created a work shedule and inputed your codes and for some reason, it's not working. Can you tell me what I am doing wrong? You will probably be able to tell what I'm doing in the sheet, but if not ask me anything about it, and I'll try to answer your questions. Thanks!!

Rosie

[HaHoBe]

Hi, Rosie,

the row numbers should be those of the range you check:

Please Login or Register  to view this content.

Is it really Q55 and not Q3 you want to colour?

Ciao,
Holger

[roseannej78]

Hi Holger,

Oops! Yes, I did mean Q3 and not Q55. I changed the case numbers and it worked beautifully!!!! Thanks a whole bunch!!!!!

Have a great day!!!

Rosie