Forum Discussion
Conditional Formatting for One Word
I have a column in my spreadsheet with descriptors written by several different people so the language isn't consistent. I'd like to use conditional formatting to find cells with one particular word. Is there a way I can do that? I tried to make a new rule to format only cells containing the one word of text, but nothing happens. Is that because that's not the only word in the cell? Is there a way for me to do this?
Here's an example of the data I am sorting. I want to highlight cells that have the word pending in them.
Thank you!
| American Literature, Supplemental Literature Circles- Pending |
| Senior English, core |
| AP Language, Core |
| Surplus by Newport |
| Senior English, Supplemental- IB Core |
| AP Language, Supplemental |
| Honors 7, Supplemental |
| Senior English, Supplemental |
| Honors 7, Supplemental |
| Senior English, Supplemental, AP Literature, Supplemental (SHS?) |
| High School, Supplemental |
| High School, Supplemental- Pending |
Hi bennettm
Give this a try:
1. Selection the column that you want to apply the formatting to.
2. Go to Home > Conditional Formatting > Highlight Cell Rules > Text that Contains.
3. Type pending into the text box and choose an appropriate format to the right. Click OK when done.
4. The results should show immediately (screen shot below of the sample data you have provided).
Hope that does the job!
Cheers
Damien
Awesome! Thanks for the quick reply!
This worked perfectly.
Megan
