my first question is
in workbook 1
A1 item qty rate avg remark
A2 bafl 500 49 49 khaya

NOW I M APLYING FORMULA IN WORKBOOK 2
I WANT WHEN A1= BAFL "KHAYA" IN WORKBOOK 1
SHOW ME IN WORKBOOK2

SECOND QUESTION IS

WHEN I APLY SUM FORMULA AND LIKE A1+B1+C1=RESULT
WHEN I GIVE REFRENCE OF CELL SHOW ME COLOR IN CELL LIKE A1 REFRENCE IN BULE B1 REFRENCE IN RED EXTRA EXTRA PLZ GUYZ I M IN TRUBLE CAN ANY ONE HELP ME HOPE U UNDERSTAND WHAT I M TRYING TO SAY

BEST REGARD
ZEESHAN MIRZA