SARFRAZ_1205
03-06-2018, 01:36 AM
Dear Sir,
I wanted to highlight duplication entries based on multiple conditions.
Example: if Column C that is entry date, Column E Vehicle number, Column G Type of expenses if same then Column B entry number should be highlighted as duplicate entry.
Example: if Column C that is entry date, Column E Vehicle number is same but columns G Type of expenses are not same then Column B entry number should not be highlighted as duplicate entry.
I wanted to highlight duplication entries based on multiple conditions.
Example: if Column C that is entry date, Column E Vehicle number, Column G Type of expenses if same then Column B entry number should be highlighted as duplicate entry.
Example: if Column C that is entry date, Column E Vehicle number is same but columns G Type of expenses are not same then Column B entry number should not be highlighted as duplicate entry.