Two sheets merged to one changing colour?

E

EARTHWALKER

Hi
If you had 2 or more spreadsheets giving the same info but in
different areas, is it possible to merge all the info into one sheet?

Week ending dates across the top, left hand side operation bein
carried out, cells are coloured in a colour according to area,
if it is possible, if an operation being carried out coincided wit
another operation would the cells then divide in colour?

Hope ive explained the question well tried to keep it simple.

I have two small examples here which show in more detail what I mean
if anyone is having trouble getting it.

Frank...where are you my saviour :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to merge cells of the same colour/pattern index 1
code to merge cells with criteria 0
Merge multiple records to one printed sheet 1
Search thru sheets to match cell contents then pick up data Phew! 3
Count Multiple Text Entries 1
Change cell colour on formula result change, no conditional format 0
A UDF for Counting Coloured Cells that are conditionally formatted 5
Complex macro issue 2

Top