conditional formatting OR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top