title: Excel Conditional Formatting using Search
body: <p>Okay so I need some more help. I am trying to use conditional formatting to put a strike through when the name in the box is put in the list above. Like shown below</p>
  
  <p><img src="https://i.stack.imgur.com/bjciU.png" alt="Picture of what I am trying to do"></p>
  
  <p>So as you can see above the 3 names below are put into a layout shown above, As they are put into a class I would like to use Conditional Formatting to put a strike through. I tried this formula:</p>
  
  <pre><code>=SEARCH(C10:C30,C3:C9)
  </code></pre>
  
  <p>This only works if the names in the box are put into each class in the same order as the box, except I can't do it that way I need to be able to jumble them into different classes and as I put them in I was hoping to put a strike through in the box to keep track.</p>
  
  <p>For Barry Houdini:</p>
  
  <p><img src="https://i.stack.imgur.com/rUqHM.png" alt="As you can see I did exactly what you said, including using the formula you told me to use"></p>