Conditional formulas for strikethrough: PLEASE HELP :(

[dannywoodgate]

Hi,

I am trying to create two different excel documents that link. On one document it has a multiple choice question. It has 4 options and the one that has been chosen will be left the same and the options not chosen will have a strikethrough.

So I want to link this particular cell to another cell in a different sheet, the three that have strikethroughs will not show up on the other sheet and the one that is normal will. I have no idea how to make the conditional strikethrough formula. Im sorry if this doesn't make sense but im kind of in a rush.

If you need more info let me know and I can provide it. Please provide a lot of detail because im a bit dim when it doesn't to excel but am a dab hand at google lol. Thanks.

 

[RickXL]

Hi and welcome to the forum,

I think what I would need to know is how will that selection be made?
Will you be entering something in a cell or using a checkbox or something else.

I would expect that to control both which line had the font changed and which line was copied to the other sheet.