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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format +OR 1
SQL Help Needed 7
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Conditional Formating 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Highlighting duplicates 0
conditional formatting 1
Stock lookup 1

Back
Top