ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Specific word - font color change (https://www.excelbanter.com/excel-worksheet-functions/253012-specific-word-font-color-change.html)

Kerrie Riggs

Specific word - font color change
 
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/tutorials...ucts-to-m.aspx

Pierre

Specific word - font color change
 
On Jan 11, 1:07*pm, Kerrie Riggs wrote:
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


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com