I have been fiddling around with Excel for ages now and cannot do what seems to be a simple task.
I have two rows of data which I want to compare. If the information matches I want the cell in the 2nd row to turn green, if the information doesn't match I want the cell to turn red.
Thus for the data below, F1&F2 should be red and F3:F9 should be green.
Can someone please help me out.