The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then click OK > OK to close the dialogs, and now, when your entered value is the specific text “N”, the entire row data will be applied the strikethrough automatically, see screenshot: And then click Format button to go to the Format Cells dialog, under the Font tab, check Strikethrough from the Effects list box, see screenshot:Ĥ. Note: In the above formula: E2 and “ N” are the cell and text value which you want to apply strikethrough based on, please change them to your need.ģ. In the New Formatting Rule dialog box, please click Use a formula to determine which cells to format option in the Select a Rule Type list box, and then enter this formula: =$E2="N" into the Format values where this formula is true text box, see screenshot: Select the data range that you want to apply the strikethrough, and then click Home > Conditional Formatting > New Rule, see screenshot:Ģ. In fact, the Conditional Formatting feature in Excel can help you to finish this task as quickly as you can, please do as this:ġ. For example, I want to apply strikethrough for the row data based on the cell value in Column E, if the cell value is “N”, to apply the strikethrough automatically for the relative rows as following screenshot shown.Īuto strikethrough based on cell value with Conditional Formatting
#How to strikethrough excel how to#
In Excel, we can apply the strikethrough to remove the unwanted cell contents manually, but, in this article, I will talk about how to auto strikethrough based on cell value. How to auto strikethrough based on cell value in Excel?