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!