How to mirror a cell's color

August 6, 2012 at 23:13:01
Specs: Windows 7
Let's say I have 2 sheets. On the first sheet, A1's cell color is filled manually. What I want to do is for A1 on the second sheet to automatically update the same color on itself.

Is there anything I can do to make this happen?

Please let me know.


See More: How to mirror a cells color

Report •

August 7, 2012 at 07:29:12
On the first sheet, A1's cell color is filled manually

Does it have to be colored manually?

If you could use Conditional Formatting to color the cell,
then you would only need to copy the Conditional Formatting.

The only other way I can think of is with some VBA code,
and my VBA skills are just above nil.


Report •

August 7, 2012 at 15:11:38
Thank you for the response!

Unfortunately the first cell has to be colored manually. I am already thinking it will have to be done with VBA too. I just dont know how :(

Report •

Related Solutions

Ask Question