Hi All,
I monitor water samples for the level of certain metals and pH. There are three conditions that need to be checked for the metals:
1. Exceeds EPA criteria.
2. Exceeds State Permit criteria.
3. Exceeds both EPA and State Permit criteria.
pH criteria are the same for both EPA and State Permit, pH shall not be less than 6.0 nor greater than 9.0.
For each metal that exceeds its criteria, I would like the cell to be color coded and the font bolded per the example in the attached workbook.
The data is kept in the "Data" worksheet. Both EPA and State Permit Criteria are listed in the "Criteria" worksheet.
I'm using Excel 2007.
Any help would be appreciated.