Here is the scenario;
A B C D
A 50 25
B 10 9
C 0.5 6
D 0.26 -0.36
E -5 0.99

I would like to be able to hide Row D because the values in column A and C
are < 1 and -1. Please note that row C and E should not be hidden because
in one of the columns the value is 1 or < -1.

I would really appreciate any help thanks

Craig