Select the range to be conditionally formatted. In this example, assume the
range begins in A1. Select Format Conditional Formatting. Instead of 'Cell
Value Is', select 'Formula Is' and enter this formula:

=AND(A1<"X",LEN(A1)0)

Then apply the formatting desired.

Hope this helps,

Hutch

"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