Conditional formatting & vlookup
Posted
by
zorama
on Super User
See other posts from Super User
or by zorama
Published on 2012-04-02T16:51:02Z
Indexed on
2012/04/02
17:32 UTC
Read the original article
Hit count: 219
microsoft-excel
|worksheet-function
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
© Super User or respective owner