Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Formats (color) Between Cells in Diff Wsheets
I've seen (my) question answered in bits and pieces (or the silver bullet has
eluded me ;) but this is the precise problem I'm trying to solve: I want sheet 1 to have a myriad of different colored cells (think tracking/scheduling) I want the ability to change the color of any one, or range of cells in sheet 1 and automatically have corresponding cells in sheet 2 change to same. I've seen partial answers involving conditional formatting and/or VB...my dream answer would be without a macro, but if necessary, can anyone point me to a complete example? (I suck with macros ;) Thanks much in advance,I've seen (my) question answered in bits and pieces (or the silver bullet has eluded me ;) but this is the precise problem I'm trying to solve: I want sheet 1 to have a myriad of different colored cells (think tracking/scheduling) I want the ability to change the color of any one, or range of cells in sheet 1 and automatically have corresponding cells in sheet 2 change to same. I've seen partial answers involving conditional formatting and/or VB...my dream answer would be without a macro, but if necessary, can anyone point me to a complete example? (I suck with macros ;) Thanks much in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep my formatting when linking cells in diff. sheets? | Excel Worksheet Functions | |||
Portions of lines being displayed in 2 diff formats simultaneously | Excel Discussion (Misc queries) | |||
how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Alternate printg 2 Wsheets to diff printers w/out reassigning ptr | Excel Discussion (Misc queries) | |||
Linking Formats Across Cells | Excel Discussion (Misc queries) |