<b>Condtional Formatting Formula</b> 1

[Texanite]

I have a text column "B" and in several cells the word "Rebill" appears. I would like to have a formula that works in conditional formatting that would allow me to highlight in yellow all cells with the word "Rebill" in the cell. The word does not appear in the same place in the string all the time. And there is different verbage in different cells where "Rebill" occurs. Can this be done?

Thanks,
Texanite

 

[cLFlaVA]

Easy.
Select the cells you wish to have this conditional formatting.
Go to Format > Conditional Formatting.
Choose "Formula Is" from drop-down.
Enter this as you see it: =NOT(ISERROR(FIND("rebill",$A1)))
Where A is the column to find the value and 1 is the first row.
Select your formatting options.

Voila.

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!