conditional formatting OR

[TimH]

I have a list of TICKER SYMBOLS in a column (the symbols in any one cell
change from day to day). I want to highlight three of them ("QQQQ", "SMH",
"OIH") using conditional formatting.
How do I do this?

[Elkar]

Select your range of cells
Select "Conditional Formatting" from the Format Menu
Change "Cell Value Is" to "Formula Is"
Enter the formula: =OR(A1="QQQQ",A1="SMH",A1="OIH")
Select your format
Click OK

*Change A1 in the above formula to match the first cell in your range.

HTH,
Elkar


"TimH" wrote:

> I have a list of TICKER SYMBOLS in a column (the symbols in any one cell
> change from day to day). I want to highlight three of them ("QQQQ", "SMH",
> "OIH") using conditional formatting.
> How do I do this?