Copy cell color

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:21 PM GMT

Question

I am trying to copy the cell color from one sheet to another. What I need is when I change the color of a cell on one of my sheets for the exact cell on another cell to also change color.

Answer

IF the cell colour is based on conditional formatting, then copying the formatting rule (as long as it is a formula based rule) will do the job ¨C if it isn¡¯t conditional formatting, the only way I can think of to achieve this is with VBA running on the change event of the worksheet ¨C I can write suitable code for you, but I¡¯d need to know which range you want to change and which range you want to update (or is it a1 on one sheet updates a1 on another?)

Question

I am trying to copy the cell color from one sheet to another. What I need is when I change the color of a cell on one of my sheets for the exact cell on another cell to also change color.

Answer

You could do this very easily by control+clicking on both sheet tabs and then changing the cell fill color. Any changes you do to the sheet are reflected on BOTH sheets.

Make sure you rightclick the sheet tab and select ungroup sheets, when you're done.

Advertisement

©2020 eLuminary LLC. All rights reserved.