Been trying to figure on what the formula should be but just can't seem to get it right.
Cells H10 to K31 have data. Column N10 to N31 have a value. I am trying to write the formula if any of the cells in H10 to K31 equal the value in N10 to N31 (H,I,J,K10 to N10..etc) then highlight the...