Spreadsheet: 744722d1629395535-complex-nested-ifs-sample
Sheet: Sheet1

Conditions (Columns A1, A2, A3) |  |  | Output based on condition AND cell should change the colour mentioned (red, dark green, etc) | Output based on Impact column AND cell should change colour mentioned (light blue, green, etc)
A1 | A2 | A3 | Impact | Potential Criticality
Low | low | low | No action -------cell should turn dark green | No action -------cell should turn green
Low | medium | low | Watch-list ------- cell should turn yellow | No action ------- cell should turn green
Low | high | low | Upskilling-required ------ red | No action ------  green
Low | low | medium | Watch-list ------- yellow | Potentially critical capability -                                  ----- light blue
Low | low | high | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
Low | medium | medium | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
low | medium | High | Upskilling-required ------ red | Likely critical capability                                    ----- light blue
Low | high | medium | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
Low | high | High | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
Medium | low | Low | Watch-list ------- yellow | No action ------- green
Medium | medium | Low | Upskilling-required ------ red | No action ------- green
Medium | high | Low | Upskilling-required ------ red | No action ------- green
Medium | low | medium | Upskilling-required ------ red | Potentially critical capability -                                  ----- light blue
Medium | low | High | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
Medium | medium | medium | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
Medium | medium | High | Upskilling-required ------ red | Likely critical capability                                    ----- light blue
Medium | high | medium | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
Medium | high | High | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
High | low | Low | Upskilling required ------- red | No action ------- green
High | medium | Low | Upskilling-required ------ red | No action ------- green
High | high | Low | Upskilling-required ------ red | No action ------- green
High | low | medium | Upskilling-required ------ red | Potentially critical capability -                                  ----- light blue
High | low | High | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
High | medium | medium | Upskilling-required ------ red | Potentially critical capability                                    ----- light blue
High | medium | High | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
High | high | medium | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue
High | high | High | Upskilling-required ------ red | Likely critical capability                                    ----- dark blue