Share via

Conditional Formatting in Word - strikethrough

Anonymous
2023-06-23T10:53:28+00:00

Is it possible to create conditional formatting or VBA in Word to change the colour of text in a table when the strikethrough function is applied.

Its a task tracker and I would like completed tasks to be turned grey when I apply the strikethrough.

Thanks :)

Microsoft 365 and Office | Word | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Jay Freedman 207.5K Reputation points Volunteer Moderator
    2023-06-23T14:07:34+00:00

    Rather than applying direct formatting to each individual cell that needs this format, define a character style that applies both the grey color and the strikethrough. Then you can apply that style to the text of any cell with one click.

    To set this up, open the Styles pane by pressing Ctrl+Alt+Shift+S, and click the New Style button (the leftmost button at the bottom of the pane). This opens the Modify Style dialog. Enter a name for the style and change the style type from Paragraph to Character. Click the "New documents based on this template" option at the bottom.

    Next, click the Format button at the bottom left and click Font in the menu. In the Font dialog, choose the shade of grey in the Font Color box, and check the box for Strikethrough, leaving everything else unchanged.

    Click OK in both dialogs. The new style will appear in the Styles gallery on the Home ribbon.

    To use the style, just select the cell(s) of the completed task(s) and click the style in the gallery.

    4 people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Jay Freedman 207.5K Reputation points Volunteer Moderator
    2023-06-23T15:37:12+00:00

    You can assign a shortcut.

    Go to File > Options > Customize Ribbon and click the Customize button at the bottom left. In the Customize Keyboard dialog, scroll to the bottom of the Categories list and click on Styles. In the list on the right, click the name you assigned to the style.

    In the "Press new shortcut key" box, press the shortcut you want to assign to the style. Here I've shown the result of pressing the Alt, Shift, and G keys together; you can select pretty much any combination you like. If the line below the Current Keys box shows "(unassigned)", that's a good shortcut that doesn't already have a function. If it shows something else, you can assign that shortcut to the style and it will be removed from whatever its previous assignment was.

    To make the shortcut stick, you must click the Assign button before closing the dialog. That will cause the shortcut to appear in the Current Keys box.

    3 people found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2023-06-23T11:18:53+00:00

    Dear Laura Backshell,

    Good day!!

    I understand your requirement but to my knowledge on the Word, its not possible to meet your requirement via out of the box way in the Word app. To check whether you can achieve your requirement via VBA, I suggest you to post your concern in the Office VBA community for getting the assistance from the VBA experts. Reference: Office VBA support and feedback | Microsoft Learn

    Moreover, I will also keep this thread open as there are Word MVPs and experts in this community having the depth knowledge on Word and VBA, so they can share their ideas and experience on your requirement.

    Thanks for your patience and understanding. Have a good day!!

    Best Regards,

    Sophia

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-06-23T14:33:06+00:00

    this is perfect thankyou. Can i create a shortcut to it or is that just with Macros?

    0 comments No comments
  3. John Korchok 231.4K Reputation points Volunteer Moderator
    2023-06-23T13:10:43+00:00

    You can do this with Find and Replace:

    1. Choose Home>Replace.
    2. With the insertion point flashing in the Find what field, click on the More button.
    3. Choose Format>Font and click on Strikethrough.
    4. Click in the Replace with field.
    5. Choose Format>Font and choose the font color you want the found text to be.
    6. Click on Replace All.
    0 comments No comments