title: MsgBox when specific cells contain specific text
body: <p>I would like to have a pop up message appear every time a cell contains specific text. Everytime the word "Red Level" is in any of this cells (I22,I23,I34,I35,I36), I would like a MsgBox to appear. 
  I am using a data validation list in all those cells mentioned above, to make sure the word "Red Level" is always the same.</p>
  
  <p>I wrote some code and it worked but only when I had 1 cell in my range. When I tried to add the other cell numbers to my code, it will still only work for the first cell and not for the rest. </p>
  
  <p>Below is the code that worked for one cell:</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)  
      If Worksheets("A12").Range("I22").Value = "Red Level" Then
           MsgBox ("Please call maintenance immediately to refill reservoir")
      End If 
  End Sub
  </code></pre>
  
  <p>I thought I could just add the rest of the cells to the range on my code, but that did not work. 
  This is what I did but did not work (The MsgBox will only appear when the word "Red Level is on I22 and not in the other cells):</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      If Sheets("A12").Range("I22,I23,I34,I35,I36").Value = "Red Level" Then
           MsgBox ("Please call maintenance immediately to refill reservoir")
      End If
  End Sub
  </code></pre>