Conditional formatting to highlight duplicate entries

[legendkiller420]

Hi,

I need to highlight duplicate entries in a range using conditional formatting. My problem is something different. I will use numbers and text "NA" in the range. I want only duplicate numbers to be highlighted and not the text "NA"

Can anyone help me?

Thanks,
Kamal

 

[Andrew Poulsom]

You can use a formula like:

=AND(COUNTIF(A:A,A1)>1,A1<>"NA")

 

[legendkiller420]

Andrew,

This wil not work coz i dont wanna use formula in the cell because if i use formula in the cell, it gets the value "0"... i want cell to blank coz i will update number/NA in the range later...

Tx

 

[Andrew Poulsom]

That was a conditional formatting formula not a cell formula.

 

[legendkiller420]

Thanks...It works...