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

"Mr P" wrote in message
...
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" wrote:

Try this:

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

Biff

"Mr P" <Mr wrote in message
...
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.