hi, p45cal

appreciate your help.
I have just tested the sample that u attached.
I found out the result dint really match what I want because the result only G & Y.
those R also turned to Y.
do you mind to take a look again?

G = there is totally NO negative value on Row Name "Proj OH" in between date
Y = if 1 or 2 negative value on Row Name "Proj OH" between Col C - Col P
R = if 3 or more negative value on Row Name "Proj OH" between Col C - Col P and negative value on Col Q - Col S.