troubleshooting Question

styling text in Microsoft Excel

Avatar of maqskywalker
maqskywalker asked on
Microsoft Excel
4 Comments1 Solution23 ViewsLast Modified:
I like to use color text in my documentation for my databases.
Color makes things easier to read.
I use Microsoft Word and Excel for my documentation.

This is an excel question.

So when I have a list of tables in my excel spreadsheet it looks like this.


Then after I add color, my list looks like this.



To add color I usually click in each cell one at a time, highlight what I want to color, then click the color from the toolbar.

For a few amount of tables this works ok.

But sometimes I have to document a database with hundreds of tables.

Question

In Excel is there a quick way to select every occurrence of a specific string and then just click Blue from the toolbar once.
That way every occurrence of that string gets colored blue.

For example, is there a shortcut way to select the text "Northwind" found in every cell all at once?
That way I don't have to click in every single cell one at a time to highlight the word Northwind and then having to click blue, eleven times.

I would like my end result to look like this. But thought there has to be a quick way to do this.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros