Conditional Formatting Based on Specific Text in Microsoft Excel! Format Good as Green. #howto #wow

In this tutorial, I show you how you can format cells based on the specific text that is within the cell. In this example, I use conditional formatting to format cells with the word "Good" with green highlighting, and bold dark green text. I also use conditional formatting to format cells with the word "Bad" with red highlighting, and dark bold red text. With this being conditional formatting, the formatting adjusts as the text within the cells change. I hope that you found this tutorial to be helpful, and if you did please like, subscribe, and comment. Thank you for watching, and I hope that you have a great day!

My Official Patron Page -

Get a fancy gadget!

Get an amazing new laptop!!

Keyboard Shortcut Cheat Sheet Anyone?

[fryeric]

Exactly what I was looking for - thanks!

[AmitRoy-omtp]

Rather than "Containing", I think it is better to use "Equal to" under "Cell Value" in the Conditional Formatting. Reason: If we use: 'Containing', the formatting can become over-inclusive. For example: 'The cell will turn Green in case of Good' and "Good boy" both. This is not intended and will make the formatting incorrect. Please correct me if I am wrong.

[TulaniMngeyiyana]

What happens when you want to only Format cells that’s containing the exact match. E.g. Jacob & Jacobs, but you only want Jacob?

[idwtv]

there are two types of text that i want to format in green should i create another rule? Is there any way we can tell excel to color a cell green when it sees either of the two words with one rule? because i have lot of words for which i need same color

[valmir]

This doesn't work with "0" as word because it will highlight 10, 20, etc