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.