Forum Discussion

lw5812's avatar
lw5812
Copper Contributor
Jun 11, 2023
Solved

Conditional Formatting Help - Highlighting based on the length of data in the cell

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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 11, 2023

    lw5812 

    Use

     

    =AND(COUNTIF($A$1:$A$100,A1)>1,OR(LEN(A1)=7,LEN(A1)=12))

HansVogelaar's avatar
HansVogelaar
MVP
Jun 11, 2023

lw5812 

Use

 

=AND(COUNTIF($A$1:$A$100,A1)>1,OR(LEN(A1)=7,LEN(A1)=12))

  • lw5812's avatar
    lw5812
    Copper Contributor
    Jun 11, 2023

    ahh... I knew it had to be something simple.
    Thank you so much!

Resources