Excel Question

[cards2468]

I'm trying to set up a spreadsheet so that if on 1 sheet I fill a specific cell with color that on another sheet(<- edit typo) a specific cell also highlights in the same color. Is this possible, and how is this done in Office 2007?

Any help would be greatly appreciated.

[StatmanCrothers]

I'm trying to set up a spreadsheet so that if on 1 sheet I fill a specific cell with color that on another sheed a specific cell also highlights in the same color. Is this possible, and how is this done in Office 2007?

Any help would be greatly appreciated.

bad news: to make changes from sheet to sheet you will probably need a Visual basic macro.
good news: its not a very complicated macro if someone already knows how to do it. i will allot five minutes to development time and report back.

[StatmanCrothers]

ah... trickier than i thought. doable, but there are some sticking points.

if anyone knows an autoformat way to do it, that would be the way to go.

[cards2468]

ah... trickier than i thought. doable, but there are some sticking points.

if anyone knows an autoformat way to do it, that would be the way to go.

thank you for your help, when I get back from lunch I'll ask around the office and see if there's any Excel gurus that know. My supervisor wants this feature on a spreadsheet that does not have much information on it anyway... I don't see why he can't just read the damn thing like a normal human being. But nooo, gotta save time when reading the spreadsheets by paying somebody to spend a few days figuring out how to cut a minute out of his reading time.

[StatmanCrothers]

if someone is familiar with the visual basic aspects of Excel, it would be relatively easy to write a macro so that, if you press a particular hot key of your choice (ALT-C, let's say) it would copy the color of the current cell to the corresponding cell on a particular sheet.

having it happen totally automatically without an extra key stroke is problematic because the macro doesn't see setting the color of a cell as a "change" to the cell the same way it would if you were adding a value to the cell or changing the contents.

[Freed Roger]

This may not be what you're after but thought I'd toss it out:

Once done with color-coordinating spreadsheet A , do a copy of entire sheet, then on spreadsheet B paste special -/formats

[StatmanCrothers]

This may not be what you're after but thought I'd toss it out:

Once done with color-coordinating spreadsheet A , do a copy of entire sheet, then on spreadsheet B paste special -/formats

that works.

[cards2468]

only problem is that the 1st sheet is a pivot table featuring data from the other sheets

[greenback44]

only problem is that the 1st sheet is a pivot table featuring data from the other sheets

You haven't mentioned it yet, but this sounds like a job for conditional formatting.

http://msdn.microsoft.com/en-us/library/bb286672(office.11).aspx

[StatmanCrothers]

hire a consultant