Duplicates in Conditional Formatting
 

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.

Duplicates in Conditional Formatting
 

Conditonal Formatting

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


"Mr P" wrote:

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.

Duplicates in Conditional Formatting
 

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.

Duplicates in Conditional Formatting
 

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

"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.

Duplicates in Conditional Formatting
 

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.

Duplicates in Conditional Formatting
 

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.