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...
Hi Hans,
Thanks for your help, but it still not working. I'm not sure if I need to change something in the formula due to having the conditional values (mylist) in sheet2 not sheet one (where A21 is located). Those values are J16 to J24 in sheet2.
Thanks for your help, but it still not working. I'm not sure if I need to change something in the formula due to having the conditional values (mylist) in sheet2 not sheet one (where A21 is located). Those values are J16 to J24 in sheet2.
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.