How do i keep my formatting when linking from one sheet to another

M

Manohar

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?
 
A

akphidelt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep my formatting when linking cells in diff. sheets? 4
Conditional formatting from one sheet to another 0
conditional formatting, filtering then copying to another sheet 0
how do I copy automatically from one worksheet to another 3
In Excel, how do I count cells with a particular format (e.g. colo 3
Conditional formatting - source data from another sheet 4
How do add another code to a current one? 4
How do I get excel to carry over info from one cell to another? 1

Top