Changing color of a cell, can it work like this?
 

I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!

Changing color of a cell, can it work like this?
 

coloring a cell doesn't fire any events, so you would need to use the
workbook level selectionchange to do your updating.

See Chip Pearson's page on events for an overview -
http://www.cpearson.com/excel/events.htm

then just use the selection change to record your rules in code.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!

Changing color of a cell, can it work like this?
 

Thanks for the super-quick response! Unfortunately, I'm an Excel
semi-novice (okay, uber-novice), and have no experience with VBA
coding, so that link went directly over my head. :( Is there something
else I could reference to help get a better grasp on this, or even see
some sample code to stare at?

Tom Ogilvy wrote:
coloring a cell doesn't fire any events, so you would need to use the
workbook level selectionchange to do your updating.

See Chip Pearson's page on events for an overview -
http://www.cpearson.com/excel/events.htm

then just use the selection change to record your rules in code.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!

Changing color of a cell, can it work like this?
 

http://www.mvps.org/dmcritchie/excel....htm#tutorials

Links to tutorials. The VBA tutorials are after the general excel
tutorials.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Thanks for the super-quick response! Unfortunately, I'm an Excel
semi-novice (okay, uber-novice), and have no experience with VBA
coding, so that link went directly over my head. :( Is there something
else I could reference to help get a better grasp on this, or even see
some sample code to stare at?

Tom Ogilvy wrote:
coloring a cell doesn't fire any events, so you would need to use the
workbook level selectionchange to do your updating.

See Chip Pearson's page on events for an overview -
http://www.cpearson.com/excel/events.htm

then just use the selection change to record your rules in code.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!