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.