Thank you very much OssiMac. It works perfectly.

"OssieMac" wrote:


=AND(COUNTIF($A:$A,A1)1,NOT(ISNUMBER(A1)))

--
Regards,

OssieMac


"BEE" wrote:

Hello Everyone,

I am using Conditional Formatting "=COUNTIF($A:$A,A1)1" to check
duplication in one column. I have texts and also numbers in the same column.
How can I make the Conditional Formatting to only check for Text duplication
and not numbers.