Hi Melissa

1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula

(For whole content of the cell)
=H1="x"

('x' within the cell content )
=ISERROR(SEARCH("x",I1))=FALSE

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Melissa" wrote:

I would like to use conditional formatting to highlight cells containing a
particular word. Is there a formula I can use in the Conditional Formatting
dialog box?