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 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.
0 Comments
Leave a Reply. |