Conditional Formatting

[prana1]

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

 

[JE McGimpsey]

One way:


Formula is =AND(A1<>"",NOT(ISERR(FIND(A1,"1234a4b4c5a5b5c6a6b6c7"))))

 

[Tom Hutchins]

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