conditional format +OR
 

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 "QQQQ", "SMH" and "OIH". Can someone tell me how to use conditional
formatting to do this?

Thanks,

conditional format +OR
 

Customized conditional format.
Formula:
=OR(F1="QQQQ",F1="SMH",F1="OIH")

HTH
--
AP

"TimH" a écrit dans le message de news:
...
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 "QQQQ", "SMH" and "OIH". Can someone tell me how to use conditional
formatting to do this?

Thanks,