|  

» Formatting Cells Containing Formulas

To format cells containing Formulas using the Conditional Formatting dialog box, add a VBA Function:

Step 1: Add the following VBA Function to a regular Module:

Function IsFormulaInCell (Cell) As Boolean
IsFormulaInCell= Cell.HasFormula
End Function

Step 2: Use the Custom Function to identify and format cells containing formulas:

1. Select the cells in the sheet by pressing Ctrl+A, in Excel 2003 press Ctrl+A+A from a cell inside a region.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select Formula is from the dropdown list.
4. In the formula box, type =IsFormulaInCell(A1), and then click Format.
5. From the Font tab, select any desired color and click OK twice.

Screenshot // Formatting Cells Containing Formulas
Formatting Cells Containing Formulas


Rate This Tip
12 34 5
Rating: 3.02     Views: 41274
great (almost) instructions
Mark
These are "almost instructions" because they lack some (perhaps) tedious but necessary information. I tried this about 5 times & had marginal results. The VBA code is incomplete. I added it to a worksheet and later got a compile error, because End Sub was not included. Is the code really complete? Is anything else missing? As for Formatting, when you hit Ctrl-A, it only selects a range of cells that are contiguous. I trid the instructions (to the letter and had no success. Cells without formulas were reformatted. Cells with formulas were are as well. Very inconsistant. I am very experienced with Excel, but if your example does not work for me, it makes me question whether I'm completely wasting my time with your "helpful tips".
It works
slaineB
In VB Editor insert new Module, and then paste the VBA code.
Click here to post comment
For Registered Users
Name
Comment Title
Comments