Conditional formatting - Highlight duplicates Only when len > 4

Hi,
searched the forum but couldn't find an answer.
I would like conditional formatting to highlight duplicate values in column C, only when cell value is over 4 characters.

Your assistance is appreciated.

thanks
Ziv

Maybe

Formula:

Please Login or Register  to view this content.

Change the C1:C10 range as necessary

Thank you for your reply,
2 issues:
1 - it gives false duplicates for long strings of texts/numbers (I'm using for USPS/UPS tracking numbers and those are typically 18 to 22 characters long)
2 - How can I apply it to the entire column (or for the first 2000 raws) without using the Format brush? (when I use the format brush is removes existing formatting from cells that have existing specific formats, all these cells (that have existing formatting) are 4 characters or less)

thanks

Would you clarify please.

Your OP said you wanted to highlight duplicates where the cell value in column C is >4 characters.

It seems from the cells you've coloured that you mean <4 characters

So your OP wasn't quite correct. You said nothing about needing to retain any manual painted cells.

Here's a CF I worked on earlier. Put it in C3 and copy down.

Formula:

Please Login or Register  to view this content.

It doesn't retain the manually painted cells in all circumstances.
We'd need to know what the rules are for manually painting the cells in order to do that.
I suspect your production workbook might have additional stuff which would help. If not then it may be that a macro is necessary.

The brush only copies the manual formatting. It won't copy a CF

Either copy the formula down or when you first create the CF in C3 use the 'Applies To' box and enter the C3:Cnn range to which you want the CF applied.

But your original post mentioned values greater than 4.
When you presented a workbook showing what you wanted it seemed you wanted matches where the values were less than 4.

You now appear to be saying that the length of the text strings is irrelevant. In which case just leave out the IF which tests for the length of the string. i.e.

Formula:

Please Login or Register  to view this content.

I feel that the following modification of Richard's formula from post #2 will do what you want:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Sorry about that.
Try the following: =AND(LEN(C2)>4,SUMPRODUCT(--($C$2:$C$49=C2))>1)
The above rule should be applied to =$C$2:$C$49
When I tested on the file only cells C29 and C44 were highlighted light red fill with red font.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.
It was important to change the references in the formula from C4 to C2 because the Applies to range starts with cell C2 i.e. =$C$2:$C$49
I hope that you have a blessed day.