title: Excel check a range for multiple values
body: <p>I've scoured Google for some assistance with this Excel problem but to no avail.</p>
  
  <p>I have four input cells A1:A4 and one output cell A5. If cell A1 contains the word "red" I want the output cell to be modified from "No" (or blank) to "Yes". If cells A2:A4 contain the words "green" or "blue", I want the output cell A5 to be modified from "No" (or blank) to "Yes". If the contents of cells A1:A4 change to any other value or are blank I want the output cell A5 to be changed back to blank or "No".  </p>
  
  <p>Once completed, the solution will be copied down a number of further rows so I need it to dynamically update either when it copies or when it executes to ensure it is referencing in the correct row. </p>
  
  <p>So far I have the following formula embedded in Cell A5 and it is working fine. </p>
  
  <p>=IF(ISNUMBER(MATCH("Red",$A1:$A1,0)),"Yes","No")</p>
  
  <p>I am struggling to incorporate the conditions I need for cells A2:A4. </p>
  
  <p>I've tried conditional formatting, VBA modules, and formulae directly embedded in the cells but am not having much luck.</p>
  
  <p>Any help would be greatly appreciated. </p>
  
  <p>-Michael </p>