Excel 2010 - Change one word in a cell to a different color

I found some vb coding that will allow me to change one word within a cell to the color red, which is what I want it to do; however, the coding will only let me change one column at a time. How can I do the entire worksheet? I tried changing the Range "A" to "A:Z" or beyond, but that didn't work. I'm not a programmer, so need help.

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Thanks to both of you for helping me out with this. I greatly appreciate it. I wanted to give some points to both of you since you both responded and helped me through this process. I tried to be fair and hope that's okay. THANKS AGAIN!!!! Have a great day!!

0

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards.
Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…