Why is do Conditional formatting with rule of format only cells that contain "~"

[nsa1]

Hello,

Add a cell with xyxyxy~. Then add a conditional formatting rule that says Format only cells that contains ~ by...
In the Edit the Rule Description:
Format only cells with "Specific Text", "Containing", ~
Format to have that Cell Filled in with some color
Then OK and Apply...

This above rule does not apply color to xyxyxy~.

If I edit above rule and instead of "Containing" I change it to "ending with" ...then the cell gets filled with color...

WHY?

NA

 

[DanteAmor]

Hi @nsa1 and welcome to MrExcel board.

Excel uses ~ to perform specific wildcard searches, so in this case, you must indicate it with double ~

Dante Amor
	A
2	xyxyxy~
3	xyxyxy
4	xyx~xxx
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A4	Cell Value	contains "~~"	text	NO

 

[nsa1]

Hi Dante,

Thanks but that didn't work with conditional formatting...

See below screenshots...

thanks,

NA

 

[RoryA]

You shouldn't have quotes around the tildes

 

[DanteAmor]