Spreadsheet: 691825d1597903737-conditional-formatting-a-cell-based-on-the-text-of-another-cell-example
Sheet: Escalations

[NAME] | Restaurant | ID | Original Action | Actual Action | Intake Agent | Notes |  |  | Total
 | C366 |  | Non-Escalation | Non-Escalation |  |  |  | 911
 | C303 |  | Escalation | Escalation |  |  |  | Escalation
 | C155 |  | Escalation | Escalation |  |  |  | Non-Escalation
 | C446 |  | Non-Escalation | Non-Escalation |  |  |  | More Info
 | C361 |  | Non-Escalation | Non-Escalation
 | C165 |  | Non-Escalation | Non-Escalation |  |  |  | High [NAME] |  |  |  |  |  | Restaurant Key:
 | C217 |  | Non-Escalation | Non-Escalation |  |  |  | 1) Immediate positive test results (when we have them or have confirmed). |  |  |  |  |  | If Cell is RED then it is a High Alert Restaurant
 | C157 |  | Escalation | 911
 | C277 |  | Escalation | Escalation |  |  |  | 2) Outbreak potential situations (multiple CMs impacted).
 | C020 |  | Escalation | 911 |  |  |  |  |  |  |  |  |  | If Cell is ORANGE then it is a California Restaurant (Overrided by HARs)
 | C272 |  | 911 | 911 |  |  |  | 3) COVID-related Hospitalizations of any kind.
 | C217 |  | Non-Escalation | Non-Escalation
 | C455 |  | Non-Escalation | Non-Escalation |  |  |  | 4) Multiple CMs that are testing. |  |  |  |  |  | If cell is YELLOW then the Restaurant has multiple cases (Overrided by HARs/CA)
 | C324 |  | 911 | 911
 | C053 |  | Escalation | 911
 | C335 |  | 911 | 911
 | C020 |  | Escalation | Escalation
 | C238 |  | Non-Escalation | Non-Escalation
 | C238 |  | Non-Escalation | Non-Escalation |  |  |  | High Alert / CA Locations |  | Total Occurances
 | C033 |  | Escalation | Escalation |  |  |  | Location # | Case count |  |  |  |  |  |  |  |  | At the moment, if any cell in column B matches the table in column I, it highlights red.
 | C324 |  | 911 | 911 |  |  |  | C118 |  |  |  |  |  |  |  |  |  | The formula for that works perfectly and is as follows:
 | C217 |  | Non-Escalation | Non-Escalation |  |  |  | C168
 | C240 |  | 911 | 911 |  |  |  | C200
 | C069 |  | Escalation | 911 |  |  |  | C287
 | C349 |  | 911 | 911 |  |  |  | C338 |  |  |  |  |  |  |  |  |  | Now I would like the above formula to factor in column E as mentioned previously to do ONE of the following:
 | C327 |  | Non-Escalation | Non-Escalation |  |  |  | C446
 | C200 |  |  | 911 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1) To do the formula above IF column E value = "911" or "Escalation"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) To STOP the formula above IF column E value = "Non-Escalation"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please let me know if you have any further questions! Thank you!
 |  |  |  |  |  |  |  | C189
 |  |  |  |  |  |  |  | C190
 |  |  |  |  |  |  |  | C200
 |  |  |  |  |  |  |  | C206
 |  |  |  |  |  |  |  | C211
 |  |  |  |  |  |  |  | C272
 |  |  |  |  |  |  |  | C281
 |  |  |  |  |  |  |  | C282
 |  |  |  |  |  |  |  | C292
 |  |  |  |  |  |  |  | C300
 |  |  |  |  |  |  |  | C320
 |  |  |  |  |  |  |  | C321
 |  |  |  |  |  |  |  | C331
 |  |  |  |  |  |  |  | C327
 |  |  |  |  |  |  |  | C329
 |  |  |  |  |  |  |  | C330
 |  |  |  |  |  |  |  | C332
 |  |  |  |  |  |  |  | C337
 |  |  |  |  |  |  |  | C338
 |  |  |  |  |  |  |  | C349
 |  |  |  |  |  |  |  | C357
 |  |  |  |  |  |  |  | C358
 |  |  |  |  |  |  |  | C365
 |  |  |  |  |  |  |  | C366
 |  |  |  |  |  |  |  | C373
 |  |  |  |  |  |  |  | C380
 |  |  |  |  |  |  |  | C384
 |  |  |  |  |  |  |  | C389
 |  |  |  |  |  |  |  | C390