Fill color of cells with conditional formatting for more than 3 criterias

Hello All,

In the attached workSheet2 I want to color rows based on text criteria. Considering Columns A, C and H. For an application with its corresponding severity level, we check the number of cycles in Col H and display specified color in Table in M5:Q13.
1) If an application has critical severity and number of cycles = 1 then display green, if its >1 then fill red.
2) Similarly for an application with High Severity and no. of cycles = 1 then display green, if its >1 fill red.
3) Similarly for an application with Medium Severity and no. of cycles < 2 then display green, if its >2 fill red.
4) Similarly for an application with Low Severity and no. of cycles < 3 then display green, if its >3 fill red.

If an application has no entry in the sheet then by default it will fill with green color. Ex: In this worksheet Application - Sony has 0 Low count and color in Q6 is Green.

I know we can use Conditional Formatting for 3 sets of criteria. So, can you suggest if its fine to use Conditional Formatting or use VBA.

@mcmahobt: The worksheet I have attached has no conditional formatting. I have manually filled the cells M6:P7 to explain what I am trying to achieve. May be I did not understand your question. As you see Sony shows Medium severity with 2 cycles in row 2, So O6 should be Green, and Critical severity has 3 cycles in row 6 so format M6 with Red.

Over all task is, Ex: M6 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 M6 with RED and if it is =1 format M6 with Green.

If an application has more than one same severity(like Apple has 2 High issues) den look for all corresponding cycles and even if one cycle > 1 den turn red for High in N7.