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
- in the conditional formatting rule it says that the formula is invalid.
If I enclose the
- with double or single quotes it does not work unless the cell literally contains
"+" instead of