Excel Conditional Formatting Escaping a Question Mark
Problem
I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn all cells with at least one character in them red. How can i escape the question mark? These don't seem to work: "?" \? '?' ??
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Excel Conditional Formatting Escaping a Question Mark
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?"
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix