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...
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
