Specific word - font color change

[Kerrie Riggs]

Is there a way to type in a specific word in an excel spreadsheet and have that word only changed to a different font color?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Serialize C# Structs To Message Queues
http://www.eggheadcafe.com/tutorial...ed-abac7b119cef/serialize-c-structs-to-m.aspx

 

[Pierre]

Is there a way to type in a specific word in an excel spreadsheet and have that word only changed to a different font color?

Submitted via EggHeadCafe - Software Developer Portal of Choice
Serialize C# Structs To Message Queueshttp://www.eggheadcafe.com/tutorials/aspnet/cc538e5f-644e-4e5b-9aed-a...

Kerrie: If thats the only word in the cell, you can use conditional
formatting to do that.
If the specific word is contained within a phrase in a cell and you
want just that word changed, there is code within this group's
archives to accomplish such. Not without it's caveats and drawbacks
however. Do search the archives. . .
Pierre