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.