data tables in Excel.

We are an environmental consulting firm seeking assistance with overhauling our soil and groundwater data tables in Excel. We routinely compare soil and groundwater sample data against lists of Soil and Groundwater Remediation Objectives to identify exceedances. We would like our spreadsheet to automatically display conditionally formatted exceedances based on various rules. We would also like our spreadsheet to automatically generate a detailed summary table based on the cells that display conditional formatting for exceedances.