Jun 11 2023 10:49 AM
Greetings
I scan four different barcodes into a single column, formatted as text, into a worksheet.
The barcodes can have the following lengths: 7, 10, 12 & 15 characters long. I need to be able to highlight the cells if they contain duplicate values, but only if they have a length of 7 or 12. I also need to allow for a cell to be skipped. I came up with this Conditional Format formula:
=AND(COUNTIF($A$1:$A$100,A1)>1,LEN(A1)=7)
But I don't know how to incorporate an additional check for the other condition of the cell length of 12.
Thank you for your consideration.
Jun 11 2023 10:56 AM
SolutionJun 11 2023 11:19 AM - edited Jun 11 2023 01:19 PM
ahh... I knew it had to be something simple.
Thank you so much!
Jun 11 2023 10:56 AM
Solution