Conditional Formatting - Highlight cell containing a specific given formula

[tstout1000]

I am trying to find a way to highlight a cells in a given range which contain a specific formula.
Example: several cells in a given range may have the formula for a VLOOKUP, others cell in the range may have a formula such as OFFSET or equal to another cell.
I want to highlight all cells that have a VLOOKUP. IS there a method to do this in Conditional Formatting?

Any help appreciated.

 

[Joe4]

You can use the FORMULATEXT function in a Conditional Formatting formula to do that (FORMULATEXT function).
For example, if you wanted to see if the VLOOKUP formula is used in cell N22, you would use this Conditional Formatting formula:

=ISNUMBER(FIND("VLOOKUP",FORMULATEXT(N22)))

 

[tstout1000]

Yes. I had just discovered that expression. I use =LEFT(FORMULATEXT(D1),3)="=VL" and highlight a certain color. Then I repeat for say"=IF", different color. Works Great! Thank you.

 

[Joe4]

You are welcome.