I have a QA spreadsheet where one tab contains the requirements and another
tab has test cases based on those requirements, with cells in them linked
i.e. '=Requirements!R6'. Shockingly the requirements have changed since the
start of the project, but when i go to the cell to mark some of the sentences
in red, the formatting does not carry through to the test cases tab. I've
tried using different colors, strikethroughs etc. but none of the formatting
is carried through. I want to keep the original requirements so that i can
show the scope creep, but without the formatting to distinguish the current
and obsolete requirements within the cell it doesn't help me.

Anyone?

Unless you do some on change event or something programming wise I don't
think that is possible with the basic functions. You might be able to set up
a series of conditional formats that can color cells on both sheets for you
if they match a certain criteria.

"Manohar" wrote:

I have a QA spreadsheet where one tab contains the requirements and another
tab has test cases based on those requirements, with cells in them linked
i.e. '=Requirements!R6'. Shockingly the requirements have changed since the
start of the project, but when i go to the cell to mark some of the sentences
in red, the formatting does not carry through to the test cases tab. I've
tried using different colors, strikethroughs etc. but none of the formatting
is carried through. I want to keep the original requirements so that i can
show the scope creep, but without the formatting to distinguish the current
and obsolete requirements within the cell it doesn't help me.

Anyone?