How to change the strikethrough color without changing the color of the text in Excel?
By default, the strikethrough color is the same as the font color of the cell content. However, you need to separate the strikethrough color and the text color in a cell for some purpose. For example, you want to keep the cell content black and make the strikethrough red as below screenshot shown. Actually, there is no method to directly change the strikethrough color without changing the color of the text. In this article, you will learn a trick to achieve it in details.
This section will show you adding a strikethrough by inserting a line in the cell, and then change the line color to your needed one. Please do as follows.
1. Click Insert > Shapes > Line. See screenshot:
2. Then draw a line on the cell text you need to add strikethrough as below screenshot shown.
3. Keep selecting the line to display the Drawing Tools tab, then choose a color for the line in the Shape Outline drop-down list under the Format tab. See screenshot:
Then you can see the result as below screenshot shown.
- How to make sheet tab name equal to cell value in Excel?
- How to change value based on cell color in Excel?
- How to change cell color when cell is clicked or selected in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!