Hi,

If Luke's intretation of your question is correct then you could use the
following formula

=MAX(ISNUMBER(FIND($H$1:$H$2,A1))*ISNUMBER(FIND($I $1:$I$2,A1)))=0

In this case you enter (X) in H1 and (Y) in H2 and X and Y in I1:I2.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"lightbulb" wrote:

I'm trying to set the conditional formatting so that if a cell contains X or
Y but does not have a begining and end parenthesis, it will turn red. How do
I do this?