Hello,
I have a series of numbers in cells B7:G17 and then a row of numbers in B25:G25.
What i am looking to do is if any of the numbers in the row B25:G25 are the same as the numbers in B7:G17, the cell in B7:G17 glows red. I tried with conditional formatting, but couldnt get the desired effect, can anyone help?
Thanks