Display in linked cell is not identical to source cell.

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Is there a formula that will link target cells in one
worksheet to be reproduced EXACTLY as the source cells are
displayed in another worksheet? Problem: If I use a
srikeout font in the source cell - it does not appear as a
strikeout in the linked target cell.
 
Thanks Dave; but, either I don't understand or I was not
clear in explaining the problem.
I maintain 3 spread sheets representing 6th, 7th, 8th
graders. I use a 4th worksheet as a "master" linking the
other 3. Updating data on a 6th grader, for example,
automatically updates the master. Sometimes, a student
moves. Rather than deleting the row, I use a strike-out
font through his/her name. I need to have the master list
pick up the change.
Perhaps you have another suggestion up your sleeve.
Thanks.
 
Patrick,

Using formatting to convey information is great visually, but problematic
when the formatting alone is used to carry the data. What you might do
instead is have an additional column, into which you would put some kind of
code, like "m" for moved. Then use conditional formatting to cause the
strikeout. If you don't want to see the m column, you could hide it, and
have a macro put in the M as needed. If you pick up the additional column
in your linked table, you can also use conditional formatting there if you
wish to see strikeout. The conditional formatting could format the entire
row, or any parts of it, based on the "m" in the additional column.

If you want some info on how to do the conditional formatting, post back.
Tell where the column(s) are, and which is to be struck out.
 
What I tried to say was that a formula can't return the formatting for the cell.

Maybe you could use a helper cell and some conditional formatting.

In your original list, add a column.
Put an X in the cells that have a cell that has a moved student.
(say column A and column B are your two columns.)

Then in column B, hit Format|conditional formatting
formula is:
=A1="X"
(and format with strikeout)

then have your other worksheets retreive both of these values in different cells
and use the same kind of conditional formatting.
 
Back
Top