在Excel中，我們可以應用刪除線來手動刪除不需要的單元格內容，但是，在本文中，我將討論如何基於單元格值自動刪除線。 例如，我想基於列E中的單元格值對行數據應用刪除線，如果單元格值為“ N”，則自動對相關行應用刪除線，如下面的屏幕截圖所示。
事實上， 條件格式 Excel中的功能可以幫助您盡快完成此任務，請執行以下操作：
1。 選擇您要應用刪除線的數據范圍，然後單擊 首頁 > 條件格式 > 新規則，請參見屏幕截圖：
2。 在 新格式規則 對話框，請單擊 使用公式來確定要格式化的單元格 在選項 選擇規則類型 列錶框，然後輸入以下公式： = $ E2 =“ N” 到 格式化此公式為真的值 文本框，請參見屏幕截圖：
備註： 在上面的公式中： E2 和“N”是您要應用刪除線依據的單元格和文本值，請根據需要更改它們。
3。 然後點擊 格式 按鈕去 單元格格式 對話框，在 字體 選項卡，檢查 刪除線 來自 影響 列錶框，請參見屏幕截圖：
4。 然後點擊 OK > OK 關閉對話框，現在，當您輸入的值是特定的文本“ N”時，整個行數據將自動應用刪除線，請參見屏幕截圖：
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 2 years agoI regularly wind up utilizing the strikethrough highlight in both Word and Excel to stamp things as finished. This component is genuinely clear in Word, as a strikethrough symbol shows up conspicuously on the Home tab in Word 2007 and later. Then again, in Excel this component doesn't have its own particular symbol, yet it has a console alternate route, Ctrl-5. However there's no worked in essay writing route for strikethrough in Word.
To post as a guest, your comment is unpublished.· 2 years agoHello everyone, I just have to say that this site is just amazing!
Much creative and extremely curricular website I have ever found while searching essay writing service on the Internet.
I am very satisfied with their work and inventory, everything looked very well and kept. I appreciate your work, keep up a great job.
To post as a guest, your comment is unpublished.· 3 years agoThis was a great help to me
To post as a guest, your comment is unpublished.· 4 years agoUsing the instructions from this page (Auto strikethrough based on cell value with Conditional Formatting) I am trying to add the proper formula to a spreadsheet with the cell value being a check mark (instead of N like the example). Ultimately, what I am trying to do is this: When I double click column A1, it will automatically add a check mark in that cell. In addition to the check mark, it will perform auto-strikethrough on cells B1 and C1. Is it possible to accomplish this? I had no problem entering a rule to add a check mark to a cell by double clicking it. And I had no problem adding the conditional formatting in order to auto strikethrough text. What I cannot seem to figure out is how to combine the 2 efforts. I do not like the idea of Check boxes and have tried that route already.