Is there a way to have my output data highlight cells that do no fit a specific criteria? (example wrong legal name)
Yes for reports and output - if you are using reporting tools you can put you data in an table for rendering. You can then create rules to display the data in various ways based upon differing criteria either by row rules (record) or by field (column rules).
Hi @MarinaC
For more info on using the Reporting Tools, check out the Reporting Interactive Training and specifically the Building Tables module
Dan
@MarinaC
Take a look at here, which have the detailed sample for how to use table rules.