Conditional Formatting
Hi Experts,
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.
Track-Data.xls
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.
Track-Data.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot for the help