Isn't is just one condition with a formula of

=ISNUMBER(MATCH(A1,{"X","Y","Z","A","B","C","D","E ","F","G"},0))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Hi,

I have 7000 rows, 5 columns.

I need to highlight the entire row if the value in column 5 is X

conditional formatting is limited to 3. I may have more than 10
criterion.
i.e. X, Y, Z, A, B, C, D, E, F, G, etc etc


Please help.
Thanks