I would like to request Experts help to create a Conditional Formatting to crosscheck data at Source sheet (column A and B) with Column A and C at Data sheet. Here's condition:
> If Data at Source sheet (Column A and B) not matched with data at Column A and C, highlight the cell at column B (Source sheet) with red color.
> If only Data B (Source Sheet) matched with data at Column C (Data sheet), highlight the cell at column B (Source sheet) with Yellow color. The conditional only active if both Column A and B (both sheet) with data (need ti ignore "--------" and other words which is not relevant.
Hope Experts will help me create this Conditional Formula. Attached the workbook for Experts perusal.