Duplicates in Conditional Formatting

[Guest]

I want a conditional format that will allow me to identify duplicate text,
however not to highlight blank fields.

=COUNTIF($N$3:$N$32,$N3)-1

The equation so far I have works but unfortunately it does colours up blank
cells which I am not wanting it to do. Does anyone have a way of solving
this within conditional formatting?

(Another options if this cannot be done, is when it sees a series of 'n/a'
the field it recognises that it does not need to colour it, only the other
duplicates.

Any help would be good. Thanks in advance.

 

[Guest]

Conditonal Formatting

=COUNTIF($N$3:$N3,$N3)>1

 

[T. Valko]

Try this:

=AND($N3<>"",COUNTIF($N$3:$N$32,$N3)>1)

Biff

 

[Guest]

Sorry Biff, this did not work I still have coloured in blank cells as a
result of this equation. Any other suggestions?

Thanks
Gary P

 

[Guest]

Thanks Biff, I used your function and changed the "" to "none" which
providing I had "none" in the cell it worked well, otherwise I got coloured
in area where there should be blank and colourless.

Thanks again,
Mr P

 

[T. Valko]

The "" in the formula is testing to see if that cell is blank/empty. If the
cell is blank/empty the test fails and *no* format is applied.

Biff