title: Using Excel "IF" Statment To Filter Out Text Beginning Or Ending With A Certain Character
body: <p>Working on the same project as before and I need to find a way to to write an "IF" statement that will search for words beginning with a "&lt;" as well as words that end with a " \ ".  I would like to conditionally highlight those cells with the value "IGNORE: HIDDEN FIELD".  </p>
  
  <p>I searched around and found that there is a <code>SEARCH</code> function in Excel but that doesn't seem to be what I'm looking for.</p>
  
  <p>Is anyone aware of how to do this?  "If a cell begins with a "&lt;" or ends with a " \ " then blah blah blah".</p>