Highlight Duplicates (clarification)

[Abner2]

Previously I asked how to highlight duplicates - I received a good response stating to put the following formula in the format field (border) section:

if previous ({Incident.Address}) = {Incident.Address} then cryellow else crwhite.

However this only highlights one of the addresses (if there are two duplicates). I would like both listings to be highlighted. How can I change this so that both or all listings of the same address are highlighted?

Thanks

 

[synapsevampire]

if previous ({Incident.Address}) = {Incident.Address}
or
next ({Incident.Address}) = {Incident.Address} then cryellow
else
crwhite.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com