lasastrack.blogg.se

For instance, you can select a fill color for the cells with formulas. Use the controls in the Format Cells dialog box to specify how you want the cells formatted.If the active cell in the range that you selected is not A1, you'll need to modify the formula slightly to reflect whatever cell is active. In the Format Values Where This Formula Is True box, enter "=ISFORMULA(A1)" (without the quote marks).In the Select a Rule Type area at the top of the dialog box, choose Use a Formula to Determine Which Cells to Format.To use this function with conditional formatting, select the cells you want checked, and then follow these steps: The ISFORMULA function allows you to highlight cells that contain formulas without using a macro. Microsoft introduced the ISFORMULA function with Excel 2013. Click OK to close the Format Cells dialog box.Click Format to display the Format Cells dialog box.In the Format Values Where This Formula Is True box, enter "=HasFormula(A1)" (without the quote marks).Excel displays the New Formatting Rule dialog box. Excel displays a palette of options related to conditional formatting. With the Home tab of the ribbon displayed, click the Conditional Formatting option in the Styles group.To use this with conditional formatting, select the cells you want checked, and then follow these steps: The following macro will do the task very nicely:įunction HasFormula(rCell As Range) As Boolean The formatting rule must be a Boolean (True/False) test, so what you do is select O1 and conditional formatting>new rule When you do, select the option for using a formula (all these steps per blog). A better solution is to use the conditional formatting capabilities of Excel to highlight cells with formulas.īefore you can use conditional formatting, however, you need to create a user-defined function that will return True or False, depending on whether there is a formula in a cell. If you need to keep a constant eye on where formulas are located, then repeatedly doing the selecting can get tedious. You probably already know that you can select all the cells containing formulas in a worksheet by pressing F5 and choosing Special | Formulas.