![]() Select the text you want to remove the strikethrough formatting.You can also use “Clear formatting” to remove it (but remember that it will remove all the other formatting as well). Just select the cells that have the strikethrough formatting that you want to remove and click on the strikethrough option in the toolbar (or in the Format option in the menu). Like any other text formatting, you can remove strikethrough by repeating the process on the text that is already formatted with a strikethrough. So if you change the status of any task from ‘In-progress’ to ‘Completed’, it will automatically get the strikethrough. One good thing about conditional formatting is that it is dynamic. The above steps would apply the strikethrough format to all the tasks where the status is completed. You can also specify another formatting if you want (such as color the cell in green) In the Formatting style section, select the strikethrough format.In the formula field, enter the following formula: = B2 = “Completed”.In the ‘Format rules’ drop-down, select the ‘Custom formula is’ option.Click on the Add new rule option in the Conditional format rules pane.This will open the conditional formatting pane on the right Select “Conditional formatting” from the options list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |