Hi, I need to do a search and replace in a worksheet. When I match a string,
I want to change the color.

For example, if the string is
"Hello everyone!"

I want to search for any word that starts and ends with 'e', then change the
word color to be blue.

Is this possible with a cell formula? Do I need a sheet macro? I cant seem
to figure it out with either!

Thanks in advance for any help! (Office 2003)