software

Column F is a formula that picks a ticker symbol out of a text string that I
cut and paste into column A. I would like to highlight the ones that pick
out quot;QQQQquot;, quot;SMHquot; and quot;OIHquot;. Can someone tell me how to use conditional
formatting to do this?

Thanks,

Customized conditional format.
Formula:
=OR(F1=quot;QQQQquot;,F1=quot;SMHquot;,F1=quot;OIHquot;)

HTH
--
AP

quot;TimHquot; gt; a écrit dans le message de news:
...
gt; Column F is a formula that picks a ticker symbol out of a text string that
gt; I
gt; cut and paste into column A. I would like to highlight the ones that pick
gt; out quot;QQQQquot;, quot;SMHquot; and quot;OIHquot;. Can someone tell me how to use conditional
gt; formatting to do this?
gt;
gt; Thanks,