I need to change the color of a cell that contains a complicated formula if
someone types in a value. Any Ideas?

M

If someone types in a value, there will no longer be a complicated formula.

You would be better off protecting that cell from editing using
FormatCellProtection followed by ToolsProtectionProtect Sheet.

But.....................to answer your question.

Copy/paste this UDF to a General Module in your workbook.

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function

Select the cell to change color and FormatConditional FormattingFormula is:

Assuming the selection to be A1

Formula is: =NOT(IsFormula(A1))


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 20:41:02 -0700, wrightlife11
wrote:

I need to change the color of a cell that contains a complicated formula if
someone types in a value. Any Ideas?

M