EXCEL - Font Color reference between cells/worksheets 1

[rji1124]

Hi... we are using Excel 2003... I was wondering if there was a way to carry font characteristics between cells and worksheets e.g.,
I have 2 worksheets in the same workbook... (A & B)
Worksheet A is an 'overview' sheet and worksheet B is a 'Detail sheet'...

I have cells on A that are pulled from B. On the B sheet (Detail), I change the font color of some cells to Red to show that field has changed - I would like to red color to show up on the A sheet automatically (without having to manually alter the A font color..

Is this possible???

Thanks

 

[AnotherHiggins]

That would require a macro (VBA). If you'd like to pursue this, please repost in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[rji1124]

Thanks... I have posted to the VBA forum...