Forum Discussion
Conditional formatting
Hi everyone, I need to create a conditional formatting to cells A21 to A39. I need them to change colors when certain values are entered. I named those values Mylist, but the problem is that thes...
Does this work?
=ISNUMBER(MATCH(A21,Sheet2!$J$16:$J$24,0))
If not, please attach a sample workbook demonstrating the problem.
Thanks Hans for your help, and sorry for not replying sooner. I ended up doing each cell separately and it worked.