View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default 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,