Conditional Formatting
 

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

Conditional Formatting
 

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

Conditional Formatting
 

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