Conditional formulas for strikethrough: PLEASE HELP :(

dannywoodgate

New Member
Joined
Sep 5, 2014
Messages
1
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,328
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,037
Messages
5,856,962
Members
431,841
Latest member
jaybeem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top