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: 222

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

Related posts about microsoft-excel

Related posts about worksheet-function