Forum Discussion
Help with Conditional formatting
I have a template that I've created, which V-lookups data from one spreadsheet into the template. I want to set up some conditional formatting that will highlight if any of the formulas in any ce...
Use a formula to determine which cells to format, then this formula (Replace A1 with the cell you are checking of course), just check to see that it is a formula containing Vlookup:
=IFERROR(FIND("VLOOKUP",FORMULATEXT(A1)),0)=0