Conditional formatting & vlookup
- by zorama
Please help me with the formula:
Main Sheet is Sheet2 B COLUMN
I want to look up sheet1 A & B columns with Sheet2 A & B columns from 1 workbook that if sheet2 A are same/equal as Sheet1 A column, also if Sheet2 B column are same/equal as Sheet1 B column , how will I highlight the Sheet2 B column that if Sheet1 A & B + Sheet2 A & B are exactly equal .
EXAMPLE:
SHEET 1 SHEET 2 SHEET 2 Result
A B A B A B
CODE NO CODE NO CODE NO
A 12 B 205 B 205 (highlight to red)
B 105 B 20 B 20 (highlight to red)
A 45 B 100 B 100
A 56 A 56 A 56 (highlight to red)
A 78 B 25 B 25
A 100 A 12 A 12 (highlight to red)
B 77 A 45 A 45 (highlight to red)
B 108 A 20000 A 20000
B 20
B 205
