Conditional formatting for cells containing calculations

[TiChNi]

I would like to use conditional formatting to highlight those cells
containing calculations. It appears that conditional formatting only
allows you to format cells that have specific results (equal to,
greater than, etc.) I just want to be able to visually distinguish
between those cells which contain formulas versus those which need to
be hard coded with numbers or text.

Thanks for you help!

 

[Gary''s Student]

You don't need conditional formatting:

Edit > Goto... > Special... > Formulas
and then apply the format

 

[Gord Dibben]

Alternate method so's you don't have to repeat the F5>Special every time you
enter new formulas in blank cells.

Copy/paste this UDF to a general module in your workbook.

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

Select all existing cells and potential cells

Then in CF>Formula is: =IsFormula(A1)

Format to a pattern and OK your way out.


Gord Dibben MS Excel MVP

 

[Gary''s Student]

Very good suggestion! (this is one I will keep)

 

[Gord Dibben]

Thanks..........James, right?

Gord

 

[Gary''s Student]

We have many names.

 

[Gord Dibben]

OK


Gord