Forum Discussion
Duplicate Invoice & Supplier
Conditional formatting to warn if an invoice has already been entered based on multiple criteria of both the supplier code & the invoice number. Is this possible? Based only on the invoice number o...
Malcolm McMaster An easy way to do this would be to add one column that combines the supplier code and the invoice number and then apply standard conditional formatting that highlights duplicates in the entire column. The attached workbook contains an example.
