CF_ISFORMULA
Feature available from Bizview version - Bizview 7.2
Important: CF_ISFORMULA is not currently supported.
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_ISFORMULA(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: