In the New Formatting Rule dialog, click Use a formula to determine which cells to format option, and enter this formula =Formatformulas ( Formatformulas is your defined name in step 3), you can change it to your own defined name. Under Home tab, click Conditional Formatting > New Rule, see screenshot:ħ. Then select your range or the whole worksheet that you want to highlight the formula cells.Ħ. Then click OK to return to the former dialog and close it.ĥ. (3.) Enter this formula =GET.CELL(48,INDIRECT('rc',FALSE)) into the Refers to field.Ĥ.(2.) Choose Workbook from the Scope drop down list.(1.) Type a name for your defined name formula, in this example, I will input Formatformulas.And in the New Name dialog box, do the following operations: In the popped out Name Manager dialog box, click New button.ģ. Open your worksheet and go to click Formulas > Name Manager, see screenshot:Ģ. Highlight formula cells with Kutools for Excel quickly and easilyīefore using the Conditional Formatting, you should create a Defined Name, please do with following steps:ġ. Highlight formula cells with User Defined Function and Conditional Formatting Highlight formula cells with Define Name Formula and Conditional Formatting With Conditional Formatting, you can highlight all cells with formulas and what's more, your highlighted formatting will be adjusted with your changing data. Here, I introduce you a better solution- Conditional Formatting. But if your data or formulas need to be changed now and then, you must apply this function repeatedly. Of course, you can select all the formulas easily and quickly by using Go To Special function. Supposing you have a large worksheet which contains both constants and formulas, and now you want to know the location of all the formula cells. How to highlight / conditional formatting cells with formulas in Excel?

Excel for mac switch rc format