formula to find cell values containing X
('x' within the cell content )
=ISERROR(SEARCH("x",I1))=FALSE
You can reduce that to:
=SEARCH("x",I1)
It'll evaluate to either the error #VALUE! or a number from 1 to LEN(I1).
When it evals as an error the format won't be applied. When it evals as *any
number other than 0* the format will be applied.
In logical tests Excel evaluates 0 as FALSE and *any number other than 0* as
TRUE.
--
Biff
Microsoft Excel MVP
"Jacob Skaria" wrote in message
...
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?
|