Conditional format - if cell contains part of formula

[Formula11]

Is it possible to carry out a conditional format for cells that contain part of a formula.
Specifically I want to format cells that have "+2" in their formula, for example "=7+2" will be formatted.
I was thinking to convert to text and then scan for the "+2", but don't know how to do this.
So far I have only a generic format for all formulas.

=ISFORMULA(A1)=TRUE

 

[jtakw]

Hi,

What if the cell formula is "=7+21"?

Look into FORMULATEXT function:

FORMULATEXT function - Microsoft Support

Syntax: FORMULATEXT(reference)

support.microsoft.com

Book3.xlsx
	A
1	9
2	10
Sheet974

Cell Formulas
Range	Formula
A1	A1	=7+2
A2	A2	=7+3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A2	Expression	=FIND("+2",FORMULATEXT(A1))	text	NO

 

[Formula11]

Thanks, I was going to use SEARCH or FIND, not sure of the difference.
The FORMULATEXT function helps a lot.
This is getting somewhere, I don't know if correct or not.
It doesn't account for "=7+21" though.

=SEARCH("+2",FORMULATEXT(A1))

 

[Formula11]

OK thanks for the suggestion.
This seems to work.

=SEARCH("+2",RIGHT(FORMULATEXT(A1), 2))

 

[jtakw]

You're welcome, if the "+2" is always at the End of the subject formula cell, you don't need SEARCH or FIND:

BTW, difference between, SEARCH is Not case sensitive, whereas FIND is case sensitive.

Book3.xlsx
	A
1	9
2	10
3	28
Sheet974

Cell Formulas
Range	Formula
A1	A1	=7+2
A2	A2	=7+3
A3	A3	=7+21

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A3	Expression	=RIGHT(FORMULATEXT(A1),2)="+2"	text	NO

 

[Formula11]

Yes you're right, thanks again.

 

[jtakw]

You're very welcome, thanks for the feedback.