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 soDoes that work for you?![]()
=ISNUMBER(MATCH(A1,$G$1:$G$6,0))
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 soDoes that work for you?![]()
=ISNUMBER(MATCH(A1,$G$1:$G$6,0))
ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks