View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bee Bee is offline
external usenet poster
 
Posts: 46
Default Select only Text duplication

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.