Excel VB help - checking conditionally formatting on one cell, applying it to another
 

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)

Excel VB help - checking conditionally formatting on one cell, app
 

Dim i as Long, j as Long, cell as Range
for i = 2 to 54
for j = 3 to 6
set cell = cells(i,j)
if cell.Value cells(cell.row,"B").Value then
Range("A54") = "The value in cell " & cell.Address & _
", [Value = " & cell.Value & "]," &
" exceeds the standard: " & cells(cell.row,2).Value
exit sub
end if
next j
Next i

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy

" wrote:

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)

Excel VB help - checking conditionally formatting on one cell, app
 

excellent! it works!

Excel VB help - checking conditionally formatting on one cell, app
 

how can i get this to update itself?

right now if i change something in the table, i have to run the macro
for the 'notes' to be updated..i know theres a simple code for this!!!