Excel Conditional Formatting Escaping a Question Mark

Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Excel Conditional Formatting Escaping a Question Mark

Message par Clippy »

Excel Conditional Formatting Escaping a Question Mark
Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Re: Excel Conditional Formatting Escaping a Question Mark

Message par Clippy »

Prefix it with tilde

```
~?

```

The tilde (~) is an **escape** character for special and wildcard characters in Excel. You can use escape characters to provide literal representations of characters that otherwise have a special meaning. You can also use tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?"
Répondre

Revenir à « Excel & VBA »