I would like to request Experts help create a conditional formatting to cross check data in column B (Source_ sheet) with data in column B (Data_sheet). The data from Source sheet (Column B) are generally listed at the end of the list in column B in the Data Sheet.
If the data on the source sheet (Column B) not available at Data sheet, the cell need to highlight with "Red" color. Please ignore data starts with "uration" and "------" during crosschecking process. Hope Experts could help me create this feature.