Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

CF_ISFORMULA

The CF_ISFORMULA function can be used to evaluate if a particular cell contains a formula or not.

The formula can be used in cell formulas and receive a parameter (e.g. =CF_ISFORMULA(C15).

  • TRUE = The cell C15 contains a formula.

  • FALSE = The cell does not contain a formula.

Use the Formula in Conditional Formatting

The formula can also be used in conditional formatting. However, then the formula CANNOT receive any parameters. In conditional formatting, only the cell in which the rule is added can be evaluated.

Select Formula in the conditional formatting and add =CF_ISFORMULA(). Then, the cell will be formatted if cell contains formula and so on.

If another cell needs to be checked in the conditional formatting then the following needs to be done:

For example, in D16 the formula =IF(CF_FORMULA(C16),"1","0") should be entered (as conditional formatting rule).

D16 will then contain a 1 or 0 if C16 contains a formula or not. Thereafter, a conditional formatting rule can be added that checks if D16 has the value 1 or 0.

Below is another example how to use in conditional formatting. This formula will color cells that DO NOT contain a formula:

CF_ISFORMULA

Published:

CF_ISFORMULA

The CF_ISFORMULA function can be used to evaluate if a particular cell contains a formula or not.

The formula can be used in cell formulas and receive a parameter (e.g. =CF_ISFORMULA(C15).

  • TRUE = The cell C15 contains a formula.

  • FALSE = The cell does not contain a formula.

Use the Formula in Conditional Formatting

The formula can also be used in conditional formatting. However, then the formula CANNOT receive any parameters. In conditional formatting, only the cell in which the rule is added can be evaluated.

Select Formula in the conditional formatting and add =CF_ISFORMULA(). Then, the cell will be formatted if cell contains formula and so on.

If another cell needs to be checked in the conditional formatting then the following needs to be done:

For example, in D16 the formula =IF(CF_FORMULA(C16),"1","0") should be entered (as conditional formatting rule).

D16 will then contain a 1 or 0 if C16 contains a formula or not. Thereafter, a conditional formatting rule can be added that checks if D16 has the value 1 or 0.

Below is another example how to use in conditional formatting. This formula will color cells that DO NOT contain a formula:

CF_ISFORMULA

For an optimal Community experience, Please view on Desktop
Powered by Zendesk