Problem with formula's and colours

[Karinann]

I have 2 spreadsheets that i can have open at seperate times. On spreadsheet #2 i have a formular to copy everything that is written on spreadsheet #1. i.e whatever i type into A1 on shreadsheet #1 is automatically put into A1 on spreadsheet #2. The problem i have is that i need the colours to change automatically also. i.e if i type in A1 #1 in the colour red, blu or black, then not only does the writing copy but also the colour. Therefore, my question is, is this possible, and if so how do i do it?!! Any help will be much appritiated. Thank you.

 

[MickG]

Hi. This is one way.
If you change a cell colour then enter or change the cell value in a cell in the Active sheet, the same cell in the nominated (in this case sheet 5) sheet changes to the Activesheet cell colour.

Private Sub Worksheet_Change(ByVal Target As Range)
 Sheets("sheet5").Range(Target.Address).Interior.ColorIndex = Target.Interior.ColorIndex
End Sub

Regards Mick

 

[Karinann]

Thank you!!

Just another question if you can, where do i enter the code!!

Sorry, I only know the basics to Excel!

Thanks again

Karin x

 

[MickG]

Hi, In the active sheet, Right click the tab, select "View code", The VB Editor window will appear. Paste all the code into the VB Blank window. If it says "Option Explicit" at the top of the window, paste it under there. In any case paste it in the window.
Exit the VB Editor
It should now work whenever you change a cell value.
NB:- Change the sheet Number in the code to suit your needs
If you want to see the VB Editor again Click "Alt + F11"
Regards Mick

 

[Karinann]

Thank you, I'll give this a go!

Karin