Tom’s Tutorials For Excel: Formatting Cells Containing Formulas, Constants, or Nothing.
As shown in the pictures, enter
Formulas as a new name.
In the Refers to field, enter the formula
Select the range of cells on your worksheet to be conditionally formatted for formulas. In this example, the selection started in cell A1.
From your keyboard, press
Alt+O+D to show the Conditional Formatting dialog.
The formula rule for cells containing formulas is
Click the Format button for your desired color for cells with formulas.
The formula rule for cells containing constants is
Click the Format button for your desired color for cells with constants.