Please see the attached file. I would like to match column A of sheet1 and column A of sheet2,
afterwards write the values of column B in sheet1 onto corresponding cells of column C in sheet2.
it would be very nice if we can highlight each cell in column B or C in sheet2 if the two values of column B and C do not match.
It can be red if one is lower and green if it is higher.
Hope i am able to convey what i need.
thanks in advance.