Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I'm trying to conditionally format a bunch of cells containing strings. If the string contains either a - or a +, the cell should be highlighted in red or green, respectively. However, when just putting a + o - in the conditional formatting rule it says that the formula is invalid.
If I enclose the + or - with double or single quotes it does not work unless the cell literally contains "+" instead of +.
Use ~ (tilde) to escape + (plus sign), = (equal sign) and also other special characters like * (asterisk) and ? (question mark) that are used as wildcards.
References
Apply conditional formatting rules - Docs editors Help
