![]() Look at the below checklist where I have used a check box with conditional formatting to apply strikethrough. Use Conditional Formatting to Apply StrikethroughĬonditional formatting is one of the best ways to apply formatting in a smart way. You can also assign it to a shape to create a button. The above code will help you to apply strikethrough on selected cells. Macro codes work like a charm and, if you want to use a VBA for strikethrough here is the code for you. Want to know the best part? You can also access other formatting options which are nowhere on the ribbon through the same. You can apply it on multiple cells and on the partial text. In the font tab, tick marks the strikethrough option.Use shortcut key ctrl + 1 to open the format options. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |