Excel Formatting

[MJamison07]

I have text in a cell in one sheet where some of the words are struckout and some are not. (Sheet1/CellA1.)

I want the contents and formatting in Sheet2/CellA1 to equal the contents & formatting in Sheet1/A1 and change when the original cell is changed. I can get that to work with an = sign for content, however, the formatting (strikeout) does not carry.

Any ideas on how I can solve this?

Thank you,
M Jamison

 

[fdgsogc]

You can try to use Conditional Formatting under the Format menu. When the cell meets a certain condition, you can format it for Font, Borders and Patterns.