How to copy the colour & content of a cell onto another worksheet

[pwoodage]

Hi

I have an excel document with more than one sheet.

Basically I manage bands and on each of the bands page I put down the name of the venue they are playing against the date they are there with a coloured box which determines what kind of gig it is (bar, wedding, function etc..)

Then I have a seperate sheet with each bands listed and do a formula to copy the exact information from the other sheets so at a quick glance I can see who is available on any given date.

Now I have no problem doing this to the point that the summary sheet copies the text and puts a '0' if the corresponding box is blank. What I would like to do is for it to copy the colour of the corresponding box too so I know at a glance on the summary sheet (I have yellow for wedding, blue for bar, purple for function, green for available and black for unavailable)

Is there anyway I can enter a formula on the summary sheet to copy the colour on each corresponding box and not just the text?

My email is [email protected] - I would be very grateful if anyone can help me. I am using Excel 2007 and Windows Vista

Thanks, Paul

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[pwoodage]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Is that ok?

[shg]

That's no better at all, Paul. Everyone that comes here wants help with either a formula or VBA. If we solve your problem, that thread title won't help anyone else searching the forum to find the solution.

Did you read the forum rules?

[pwoodage]

That's no better at all, Paul. Everyone that comes here wants help with either a formula or VBA. If we solve your problem, that thread title won't help anyone else searching the forum to find the solution.

Did you read the forum rules?

I did! Sorry - think I now have it. That ok?

Can you help me!

[shg]

You can't copy formatting with a cell formula.

Instead of manually coloring the cells by type, consider adding a column for the type of gig, and using that column to color the cells using conditional formatting. See http://www.contextures.com/xlcondFormat01.html

[pwoodage]

You can't copy formatting with a cell formula.

Instead of manually coloring the cells by type, consider adding a column for the type of gig, and using that column to color the cells using conditional formatting. See http://www.contextures.com/xlcondFormat01.html

OK SHG thanks - I will give it a whirl.

[NBVC]

probably best to remove your email address...for your protection