Excel conditional formatting for multiple words
<p>I am trying to highlight or color words using conditional formatting in Excel.</p>

<p>For example, in a single column in may have over 100 rows ranging in words such as <code>apple</code>, <code>berry</code>, <code>water</code>, <code>blue</code>, <code>red</code> and <code>shoe</code>. </p>

<p>I am trying to highlight specific words in the cell within the column. Using that example I would like to highlight <code>apple</code>, <code>berry</code> and <code>red</code>. </p>

<p>Rather than doing multiple conditional formats, I am trying to do this in a single session. How would I go about doing this?</p>

<p>Thank you.</p>