From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Tracking and highlighting formula cells with the ISFORMULA function

Tracking and highlighting formula cells with the ISFORMULA function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tracking and highlighting formula cells with the ISFORMULA function

- A new function introduced in Excel 2013 is called isformula, and it seems pretty basic. For the most part it is: we simply want to know, does a cell contain a formula or not? =isformula( I'm referring to cell G2. My answer will be true or false. That's false. I'll drag it down the column here, across the empty cells, and what do we see? We've got formulas there. To the left, those are formulas. We can certainly see them in the formula bar. We might want to use it with conditional formatting to highlight all the cells that have formulas in them. Furthermore, it's going to be dynamic if we apply this to the entire worksheet. In other words, let's say whenever there's a formula, we want it to be yellow, green, blue, whatever. As we add new formulas, make those cells change color. If we erase cells with formulas, make them have the color be removed. Let's select the entire worksheet and go to from the Home tab, Conditional Formatting, and create a new rule, a new formatting rule. Use a…

Contents