Archive of Mr Excel Message Board

If a cell in a given range does not contain a formula, that cell must have e.g., a specific color as background. Is this what you want?

Aladin

> Yes, that is what I am after

Terry

Activate the option Tools|Macro|Visual Basic Editor.
Activate the option Insert|Module.
Paste the following in the open space on the window with title having the "(code)" bit:

Function ContainsFormula(cell) As Boolean
ContainsFormula = cell.HasFormula
End Function

Activate the option File|Close and Return to Microsoft Excel.

Select the range, say A1:A10, where you want to apply conditional formatting.
Activate the option Format|Conditional Formatting.
Choose "Formula Is" for Condition 1 on the Conditional Formatting window.
Enter the following formula:

=NOT(CONTAINSFORMULA(A1))

Note. Enter just A1, not $A$1.

Activate the Format button.
Apply the formatting that you want.
Click OK.

Aladin

An example workbook is underway to you.

Aladin

> If a cell in a given range does not contain a formula, that cell must have e.g., a specific color as background. Is this what you want? Activate the option Insert|Module. Paste the following in the open space on the window with title having the "(code)" bit: ContainsFormula = cell.HasFormula End Function Activate the option Format|Conditional Formatting. Choose "Formula Is" for Condition 1 on the Conditional Formatting window. Enter the following formula: Apply the formatting that you want. Click OK.