title: Formula to conditional formatting text that contains value from another cell
body: <p>I have a column A that contains a 1-4 word phrases in each cell.</p>
  
  <p>I also have 4 cells that contain 1 word values:</p>
  
  <p>B1 C1 D1 and E1</p>
  
  <p>I need to setup conditional formatting is such a way, that:</p>
  
  <p>1) If text in a cell from column A contains a word that matches value from ONE of the cells mentioned above, highlight that cell (from column A) in red.</p>
  
  <p>2) If text in a cell from column A contains words that matches value from TWO of the cells mentioned above, highlight that cell (from column A) in blue.</p>
  
  <p>3) If text in a cell from column A contains words that matches value from THREE of the cells mentioned above, highlight that cell (from column A) in yellow.</p>
  
  <p>4) If text in a cell from column A contains words that matches value from all FOUR of the cells mentioned above, highlight that cell (from column A) in green.</p>
  
  <p>View an attached image for illustration:</p>
  
  <p><img src="https://i.stack.imgur.com/HTmvn.jpg" alt="Example"></p>
  
  <p>When I change a value in any of B1 C1 D1 or E1 cells, I want it to be reflected in the column A, if not immediately then by the means of running some sort of macro.</p>
  
  <p>I suspect it should be either conditional formatting by formula or by running some sort of macro...</p>
  
  <p>P.S: I use Excel 2010</p>