Hi
Basically, I would like to know the function to enter in conditional formatting where it can highlight cells that does not match with other specified columns.
I have attached a workbook and wtitten a description in there to better visualize it.
Based on the example in the excel sheet, I've tried using this but it still does not return as per intended:
=LOOKUP(6,1/((C$1:C1=C2)*(H$1:H1=H2)),G$1:G1)<>F2
Appreciate if I could get some help. Thanks
Bookmarks