Fill colors of cells using Conditional formatting based on 3 criteria

Hi,

I have a spread sheet3 with Application, Severity and Count as Column names. I want to define a table for each application and corresponding severity level and display colors based on number of cycles. If number of cycles for Critical, high issue is >1 then respective box in table fill Red Color else fill Green Color. For Medium and Low severity, if cycles >2 then display red in respective box else display 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.


Please help me with a solution.