Conditional Formatting with Formula Containing

short answer - no, not in 2010

=isformula() came out in 2016, I think

Hi jp,

I don't think this is possible in Excel. You do have a tool called "Show Formulas" on the Formulas Tab. Also, there is a tool in PUP 7 that will list all formulas on a sheet or the workbook. It is under Reports and then Formula Report.


http://spreadsheetpage.com/index.php/pupv7/home/

@ Marvin, I have 2016, and just tested ISFORMULA() in CF and it worked

Hey Ford,

Glad you're back and keeping me honest. But this OP wanted to mark all cells that had a formula and a VLookup() in them. Can we get there with just the IsFormula()?

Stents?

OK, I missed looking for a specific function, but looks like it is still possible...
CF rule =SEARCH("vlookup",FORMULATEXT(D31))

Can you attach a worksheet that shows it doing its thing? I've tried to put your formula in a CF rule without success. I must be missing something (and I'm not great with CF anyhow).

Hey Ford,

I woke up this morning remembering Format Painter and finished this problem. YOU ARE Correct. The Conditional Formatting formula to pull out formulas with "Vlookup" in them is:

=SEARCH("VLOOKUP",FORMULATEXT(A1))

and then apply this rule to the whole worksheet some thing like:

=$A$1:$AA$1000

Thanks for the correction. It is possible to CF a certain formula function!

Thanks Marvin. I really only tried that for the 1st time, on this question, so it is a good technique to remember. Thanks for the feedback