Excel 2003
one way:
FormulaIs
=AND(A1<"pharmacy",A1<"drug",A1<"rx",A1<"scrip t",A1<"shoppe")
and select red fill pattern
then copy pastespecial as formats


On 26 Lut, 17:13, Daren wrote:
Hello,
I have many records that include pharmacy, drug, rx, script, or shoppe in
them. *I need a conditional format to highlight these cells in red when the
cells do NOT satisfy the pharmacy, drug, rx, script, or shoppe criteria. *Can
you assist with the formula?

Thanks.