copy cell color not contents

August 8, 2011 at 04:09:41
Specs: Windows XP
i have got A2 and e2 , if e2 is smith and red then a2 will also be red, if e2 is robb and green then a2 will also be green, not content nothing, just the cell color needs to be copied, i have written vba code for the drop down menu in E2 , with color codes and its perfectly ok, but i am stuck with this color copy.
also when a2 is green in sheet 1 , c2:f2 of sheet 2 will also be green.

can pls someone help me with that?...conditional formatting not goiung to help as i need five different colors and CF can only do 3, i am using mso 2003.


See More: copy cell color not contents

Report •

August 8, 2011 at 19:19:13
This line will cause E2 to be filled with the same color as A2:

Range("E2").Interior.ColorIndex = Range("A2").Interior.ColorIndex

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question