No problem, thanks for the clarification. The below code should work for you.
To insert this code into your workbook
1. Select the worksheet that contains that values
2. Right click on the worksheet's tab
3. Select the view code option
4. In the blank space provided copy and paste the above code, anything that appears in green is a comment meant to help you understand. Also, there are lines that tell you how to adjust it if you want to programmatically color the cells.
5. Close out of Visual Basic
To test the code:
Double-click on a cell the contains the word John.
Let me know if this is what you were looking for.
Thanks!
Bookmarks