Macro to Change Font Color in Portion of Cell

I want to change the font color on certain words within a cell. Each cell has several phrases and everytime there is a space of 3, then I want the next phrase to alternate = font blue. Next phrase font black.

I have no idea how to go about this. This is horrible.

Please Login or Register  to view this content.

If this is not what you want, need to see before/after format.

Please Login or Register  to view this content.

Hi

This code will change the Font Color of the Three Cells listed in line 2. You can add as many cell references as you want

Please Login or Register  to view this content.

Jindon. That code is so beyond me it isn't even funny. It turned some words blue but not the entire phrase. For some reason it always changed the font of "Reason". Not sure if that's a coincidence. Then my computer crashed.

mehmetcik, I'll have to check your code out on Monday. I gotta say, I usually like to understand the code I'm using; even if I couldn't come up with it. But the majority of this I'm totally clueless on.

Do you mean like this?
Try the attached