In conditional formatting, how do I highlight cells that with some specific symbols?

Hi,

For some special customer, we will put a symbol in front of the customer name for some meanings. Usually it is # and $.
1.jpg

May I know how can I let the Excel highlight the cells that contain "#" and "$"? I tried to go to "Text than contains", but cannot enter 2 symbols; and tried to used formula but still could not find the correct formula to be used.
2.jpg

Thank you.

HI,

You have to create 2 rules in condition formating. See picture.

Use this.
Add COUNTIF for other symbols.

Formula:

Please Login or Register  to view this content.

Opposite than Special-K solution this will find symbols in any part of the text. Not only first.

Originally Posted by Special-K

Select cell A1

Conditional Formatting
New Rule
Use a formula to determine...

=(OR(LEFT(A1="#",A1="$")))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

Hi Special-K,
I tried to use this on A1, however not sure why it did not highlight the cell
3.jpg

Originally Posted by stylemonk

HI,

You have to create 2 rules in condition formating. See picture.

Hi stylemonk,
Now I just learnt that I can create 2 rules for the same range. Thank you.

Originally Posted by zbor

Use this.
Add COUNTIF for other symbols.

Formula:

Please Login or Register  to view this content.

Opposite than Special-K solution this will find symbols in any part of the text. Not only first.

Hi zbor,
Hmm. It works, though I dunno the function of countif. I will go and check more