Logical Formulas | General Excel Questions & Answers | Excel Forum

Hi

I am looking for help to apply conditional formatting (logic formulas) on the attached sheet where I would like to apply conditions in one cell as follows. At the same time, some of the criticality will be low and and ingerty will be high. I would like to return the anwer on the group cell

1. If any HIGH CRITICAL station is RED, then group = RED.
2. If greater than or equal to 50% of the HIGH CRITICAL stations are AMBER (and no less than 2) then Group = RED
3. If greater than or equal to 70% of MEDIUM CRITICAL stations are RED 9 (and no less than 3) then Group = RED
4. If less than 50% of HIGH CRITICAL stations are AMBER & greater than or equal to 70% of MEDIUM CRITICAL stations are AMBER then Group = RED
5. If any HIGH CRITICAL station is AMBER, then Group = AMBER
6. If any MEDIUM CRITICAL station is RED, then Group = AMBER
7. If greater than or equal to 50% of MEDIUM CRITICAL stations are AMBER (and no less than 3), then Group = AMBER
8. If greater than or equal to 70% of LOW CRITICAL stations are RED (and no less than 2), then Group = AMBER
9. If less than 50% of MEDIUM CRITICAL stations are AMBER & greater than or equal to 70% of LOW CRITICAL stations are AMBER then Group = AMBER
10. All other conditions that do not fit into the above scenarios, the Group = GREEN.

Regards,

Shameen