Microsoft Office Tutorials and References
In Depth Information
Using the ISFORMULA Function with Conditional Formatting to Mark Formula Cells
Using
Using the
the ISFORMULA
ISFORMULA Function
Function with
with Conditional
Conditional Formatting
Formatting tto Mark
Mark
Formula Cells
Formula Cells
The Excel team introduced the ISFORMULA function in Excel 2013 to identify
whether or not a cell contains a formula. A hack had been floating around
for years to mark formula cells using an old XL4 Macro Language function.
Being able to use ISFORMULA is a great improvement.
Syntax
ISFORMULA(reference)
Checks whether referencecontains a formula. Returns TRUE or FALSE.
Figure 12.11 shows a worksheet where all the cells have a conditional
formatting formula that uses =ISFORMULA. Any cells that contain a for-
mula are shown in white text on black fill.
Figure 12.11.
Figure 12.11. Use the new
Use the new ISFORMULA
function with conditional formatting
to mark all of the formula cells.
ISFORMULA function with conditional formatting
to mark all of the formula cells.
Search JabSto ::




Custom Search