Hi... I'm new to this forum, but have learnt a lot from it in the "past"
I now have a thing that I can't solve on my own - I have, say ten sheets in a workbook, and the first one is there to store info to be used in the other sheets.
I now want to have a range of cells coloured in the same colour on all or some sheets, and should therefor make a cell in the infosheet that colour to get from (=infosheet A1)
This command will not copy the colour but only the data in that cell. I have been told from my workmates, that there's no way to do this.
That I don't believe, on a complex program as excel this is no problem. Only thing is that I don't know how to do it.
Is this possible, and how - please let me show my collegues that i'm not that thick and let me use my time to other things than colour areas manually. Thanks in advance.
I'm using excel 2003
I now have a thing that I can't solve on my own - I have, say ten sheets in a workbook, and the first one is there to store info to be used in the other sheets.
I now want to have a range of cells coloured in the same colour on all or some sheets, and should therefor make a cell in the infosheet that colour to get from (=infosheet A1)
This command will not copy the colour but only the data in that cell. I have been told from my workmates, that there's no way to do this.
That I don't believe, on a complex program as excel this is no problem. Only thing is that I don't know how to do it.
Is this possible, and how - please let me show my collegues that i'm not that thick and let me use my time to other things than colour areas manually. Thanks in advance.
I'm using excel 2003
Last edited: