Formula to color field when duplicated

[austin22]

I am using Crystal 8.5 and I have data that duplicates the case number periodically. See as follows:

123
456
789
789
789

I want to color or highlight the cases that are duplicated in my data. Please advise.

k

 

[lbass]

if {table.caseno} = next({table.caseno}) or
{table.caseno} = previous({table.caseno}) then
crYellow else
crNoColor

-LB

 

[austin22]

Thank you so much.