Conditional Formatting Excel 2003

[jef]

Need for conditional formatting to be TRUE if a cell is equal to any
of several cells.

Trying to use conditional formatting formula in cell A20: =IF(G20=J$8:J
$12,TRUE,FALSE) so as to have the condition (color condition for A20)
to be true. G20 contains the letter "E," and J8 through J12 contain
C-, D+, D, D- and E. This does not work

The condition works fine for single cell comparatives as follows: =IF
(G20=J$12,TRUE,FALSE), where J12 contains an "E" and G20 likewise
contains an E.

I tried naming the range of cells containing the letters (LowRatings)
and used the following formulas: =IF(G20=LowRatings,TRUE,FALSE) or =IF
(G20="LowRatings",TRUE,FALSE) - but these did not work either.

The reason I can't use single letter conditions is that Excel 2003
allows only 3 conditions, and the number of letters I have are 5.

In essence, I am trying to get around the Excel conditional formatting
limitation of only 3 conditions - and I do not want to use any VBS or
macro alternatives.

Am open to possible other alternatives.

 

[Dave Peterson]

You could use:
=countif(j$8:j$12,g20)>0

(You don't even need the >0 characters. But I like them. I think that they
help document the expression.)