| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
| Changing Cell Color | Excel Discussion (Misc queries) | |||
| Changing color of cell | New Users to Excel | |||
| Changing Cell Color | Excel Worksheet Functions | |||
| Changing cell color | Excel Programming | |||
Linear Mode
