I'm trying to conditioan format a bunch of cells that are strings by having cells with a - red and cells with a + green. However when just putting a + o - in the conditional formatting rules it says it is an invalid formula.

If I enclose the + or - with double or single quotes it does not work unless the cell literally contains "+" instead of +.

enter image description here


Use ~ (tilde) to escape + (plus sign), = (equal sign) and also other special characters like * (asterisk) and ? (question mark) that are used as wildcards.

Conditional Formatting

Apply conditional formatting rules - Docs editors Help


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.