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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,325
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,841
Messages
5,598,390
Members
414,234
Latest member
grlevesq

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