IsFormula



Identify at a glance which cells contain formulas.


 * 1) Select a range of cells, with A1 as the active cell of the selection.
 * 2) Select Format
 * 3) Select Conditional Formatting
 * 4) Under Cell Value Is select Formula Is
 * 5) Enter =IsFormula(A1) in the Formula box.
 * 6) Click Format Button
 * 7) Choose formatting (bold italic used in this example)
 * 8) Click OK
 * 9) Click OK
 * 10) (If Excel puts quotation marks around the formula by assuming it is text data, remove quotation marks and click OK)