One way:


Formula is =AND(A1<"",NOT(ISERR(FIND(A1,"1234a4b4c5a5b5c6a6b 6c7"))))



In article ,
prana1 wrote:

Hi,

i have a range of values that are either blank, are one of the values from
the list below, or have an "X" in each cell.

If I only want to affect the values that match the list, so that ones that
are an "X" or blank are not affected, how could I do so?

1
2
3
4a
4b
4c
5a
5b
5c
6a
6b
6c
7


Thanks,

Eric