I would need help figuring out how to check two values, row by row, and then determine one or another event.
In my table, there are two columns on which I need to check volumes.
Column: Original File
If inside the table, the original file is> 100
and on the same line, the percentage is> 30, then I check (xx) Otherwise, (yy).
The problem is that the value must refer to the whole table, that is, it is enough just for a row of the whole table to exceed this threshold, then xx, otherwise yy.
I tried to check a For Each Row loop, but obviously, when I pass over the line, the variable sets itself to xx,
while when I pass on the last one, yy is set.
It must remain xx, because if even one value is over the threshold, an alarm must be activated.