Can I used conditional formatting to high duplicates in reports?
We have several grant programs within our organization and I am working on funneling all the form submissions from each into a main report. I would like that report to identify duplicate submissions so I can consolidate and make sure candidates aren't overwhelmed by having too many cases open. Can I use the conditional formatting to cross reference Last name and DOB to highlight a duplicate? Or is there another solution? Thanks!