References and formulas are not allowed for conditional formatting Text that Contains rules. If you are searching for text ...

References and formulas are not allowed for conditional formatting Text that Contains rules. If you are searching for text that contains, does not contain or ends with hyphen (-), plus sign (+), or equal sign (=), use the wildcards asterisk plus hyphen (*-), asterisk plus plus sign (*+), and asterisk plus equal sign (*=) respectively. The wildcard cannot be used at the beginning with Text that Contains rule.