Conditional Formatting

  • Thread starter Thread starter prana1
  • Start date Start date
P

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
 
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
 
Back
Top