Duplicates in Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
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
 
Back
Top