Hi and sorry for the delay in responding to your kind advice, just to clarify I have attached a mock up of the type of thing I need. The information in range C3..E7 is compared with range G3..I7 In my example D4 does not match with H5 so both corresponding rows in the ranges are highlighted.
Bookmarks