Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting OR
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting OR
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |