I have provided an example at http://HelpExcel.com/examples
The name of the file is colorNo.xls
--
http://HelpExcel.com




"b4nature" wrote:

I want to change the color of part of a string of text in a cell, not the
whole cell. I know I need a macro but am not a knowledgeable VB user.

Would someone be willing to share code with me that would change the color
of the word "no" to red when found within a string in a select group of cells.

Hopefully what I am asking makes sense!
Thank you!