How to Automatically Color Code Specific Words or Phrases in Excel

How to Automatically Color Code Specific Words or Phrases in Excel.

If a cell contains multiple words, how can you highlight a certain word only in this cell? And how about highlighting this certain word in multiple cells? This tutorial will provide a method to achieve it.

[janetjandrositz]

What if I just want one word in a sentence highlighted or colored?

[nirmalrana]

1:02 @ this timestamp, I paused the video, opened my Excel and Solved the Problem. Thanks bro. Will keep watching your channel.

[shannonfloyd]

Sweet, short, simple, to the point and exactly what I needed. Thank you!

[hopehouse]

thanks so much. I was at my wits end...which is usually where I get before I search for Excel tutorials. Amazing and thanks again!

[gangaindenial]

What if there is more than one word (not next to each other) in the cell that you want to highlight a certain colour? I have two different clients that I am servicing & would like to differentiate the two but they will both contain 1 keyword that is the same in each cell as well as 1 unique identifier (client name) with other text in between the criteria?

[practicaldeen]

Much appreciated. Was able to help my Mum on this one. !!!!

[natnathutchins]

Thanks so much! Just wanted to say this gave me a GREAT laugh!!! I sat at my computer for about an hour trying to search and replace text to a strike through like in Word.

OMG! I totally forgot about this in excel. And this is something I use the time! Needless to say “it’s Monday”!! Thanks 😊🤪

[dianamarshall]

Thanks a million!  I was desperate to highlight words I "find" and I hope this will do the trick.

[Skeltcher]

How do I do that but extend the cell color to the entire row?

[HeroVax]

Thank you so much. I'm using this for my financial excel. Paid or Due

[msbrown]

so after i do this, will it automatically color code the specific words down the line if i were to add more data?

[chelseaabell]

What if I want it to highlight the entire ROW after I put a specific word into a cell? I got it to highlight the cell but I want the row to highlight..thanks

[qkyrphe]

your video tutorials are very helpful! but sometimes i have a situation like thi:
sheet 1, sheet 2. there is a cell (B10) in sheet 2 containing "there is a colored word in a sentence" where the word "word" is color red.
in sheet 1, i put in cell(A1) " =B10 ", but but the refence with show ill text in black color. i want an outcome that the colored word to be still in color red.
any idea how to do this? Thanks in advance!

[leeparry]

How do you do this so it works for multiple tabs?

[nyghtwav]

Hey man! You are coloring the cell here, not the word. How would one go about coloring a specific word in the entire sheet, just the word, not the cell?

how would i format multiple values (such as Likely and Usually), do I have to do it seperately or can i do two at once?