This Formula worked perfectly right. Thank you

So, what I meant in my first post was to find number of cycles for each criteria and even if one of them exceeds our limit then turn Red else Turn Green.

Example - As you see Sony shows Medium severity with 4 cycles in row 2, So M8 should be Red, and Critical severity has 4 cycles in row 6 so format K8 with Red.

Over all task is, Ex: K8 represents Sony with Critical issues. So we look at data for Application name Sony and Severity be Critical and there corresponding number of Cycles. If any cycle value is >1 then format K8 with RED and if it is =1 format K8 with Green.

If an application has more than one same severity(like Sony has 2 Critical issues in Row 6 and Row 26) den look for all corresponding cycles and even if one cycle > 1 den turn red for High in K8.
Hope I am clear this time.

Regards