Hi,

Luke may be correct but you really need to specify the possible data layouts
for example

Hi Luke,

I can't get that to work if the data is, for example what do you want to do
with the following:

ab(m)x
ab(abxu)
a()x
abd(xy)
def(mmm)x
(x
y)

but then we don't know if the user data can look like any of the above.
--
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?