Need help with Formatting

[mudkum]

I need to format a text based on certain conditions. Basically,if the value of the cell is one out of the 15 values, then its text should be formatted (strikethrough)

I know I can use Conditional formatting for up to 3 values, but my need is for up to 16 values and these are not numbers. Thus, if the value of cell is anything out of (A,B,C,D,E,F,G,H,I , J, K , L ,M N, O , P) then it should change the formatting of the cell.

[ChemistB]

You need to put all your terms in a column and then refer to that column (in my case G1:G6) in the conditional formatting like so

=ISNUMBER(MATCH(A1,$G$1:$G$6,0))

Does that work for you?

ChemistB