I am creating a table in which we are inputting our test results and
comparing them against the standards. I have conditional formats on
the empty cells where we input our data that if it exceeds the
standards, then the cell is shaded gray and the text bold and
italicized. i wish to have it so IF there are any exceedances in the
table, then the first exceedance found in the table is displayed in the
notes section below the table with an explaination. please help!!

col.A - chemical name
col B. - standards
col C-F - blank for now, where we input our data

for example, say C12, E45, F2 all exceed their respective standards
(therefore cells are shaded/text bolded, etc due to conditional
format), i want to program cell A54, which is below my table, to
display C12 and have text beside it explaining what it means (ie:
denotes exceedance of table blah blah blah)