VBA to change the color of a word if it appears.

handysmurf

Board Regular
Joined
Jan 17, 2015
Messages
97
Office Version
  1. 365
Platform
  1. Windows
just the word (or string) itself, not the background and not all the words in the cell. This would be based on a list of words that appear in column FD. In some cases it would be several words together such as "head up your ***". Most are just one word. Its fine if it just works on the entire sheet and I want them to be bright red FF000 and bold. Also, in one case, what I'm looking for is "pos" ... which appears in many words but I only want it to highlight if it stands alone.

I've found some similar threads but I don't know enough about VBA to make the changes necessary to do what I need.

Thanks in advance
 
1716699939181.png
 
Upvote 0

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Ok ... I've been playing around with it .... it is working. It is very picky but that is ok now that I have figured it out.

I want to run this when I save the workbook. I tried to do a sub to set the range it looks in, which worked. I tried to do a sub to run the "setrange" then your formatting sub. I broke it and had to back peddle.
 
Upvote 0

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top