Hi -

I am working on an excel database that is relatively large - about 23,000 rows. Multiple individuals are inputing new data every month into this spreadsheet. Thus, there are frequent errors, often in different columns, in different rows.

I am looking for a way to call attention to the rows in which there is an error. Is there a way to highlight all rows in a table where there is an error within any cell within the rows?

I have attached a much smaller version of the table I am working with.
PM2A Beneficiary Data _Excel Forum_3-18-2013.xlsx