Written by Allen Wyatt (last updated June 16, 2018)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365
When searching for text in a document, it is easy to search for formats such as "bold" or "italic." You can also search for "not bold" and "not italic." You can search for text of a specific color, but Word does not allow you to search for text other than a specific color. For instance, you cannot search for text that is "not black."
If you need to search for text that is not black, then the best way to do so is with a macro. Consider the following macro, which prompts you for your search text, and then looks for the first non-black instance of that text.
Sub FindNotBlack() With Selection.Find .ClearFormatting .Text = InputBox(prompt:="Enter the search text.", _ Title:="Find Nonblack Text") Do While .Execute With Selection.Font If (.Color <> wdColorAutomatic) And _ (.Color <> wdColorBlack) Then MsgBox "Found" Exit Sub End If End With Loop End With End Sub
Note that the macro checks to see if the color of the matched text is different from black (wdColorBlack) and from the automatic color (wdColorAutomatic). This is because the automatic color is black on most systems.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11644) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. You can find a version of this tip for the older menu interface of Word here: Searching for Non-Black Text.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Need to look for a piece of text possessing a particular formatting attribute? Here's the skinny on how this is accomplished.
Discover MoreWord makes it easy to find text that uses a particular font or font characteristics. What it doesn't do is make it easy ...
Discover MoreWant to find all the paragraphs in your document that have borders applied to them? The regular Find and Replace tool ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-03-17 02:18:24
JW
Thanks for this! It is very close to what I was seeking.
Is there a way to tweak it to find ANY text that is not black or "automatic"?
Thank you!
2018-10-11 11:37:16
Cooper
Hello Allen, this is a very helpful article! However, I'm curious to know how to run a continuous search for a specific color. I tried using your code as a test and replacing "wdcolorautomatic" and "wdcolorblack" with my RGB scale color (B=255) but to no success. I also want to avoid bolded text. Any tips for expanding this macro?
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments