Auto Fill Color Cell
 

Hi all,

I need some help. I'm looking for a way to do this. I have columns with
formulas. And sometimes those formulas in a particular cell or 2 are
overwritten with a "hard" number. Is it possible to somehow make it so that
when someone changes the cell to a number that it turns the cell yellow
automatically?

Please help.

Thank you!!

Auto Fill Color Cell
 

Copy this to general module in your workbook

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

In FormatCFFormula is: =IsFormula(cellref)=FALSE

Format the cell(s) to yellow.


Gord Dibben MS Excel MVP

On Mon, 14 Jul 2008 11:56:00 -0700, Steve
wrote:

Hi all,

I need some help. I'm looking for a way to do this. I have columns with
formulas. And sometimes those formulas in a particular cell or 2 are
overwritten with a "hard" number. Is it possible to somehow make it so that
when someone changes the cell to a number that it turns the cell yellow
automatically?

Please help.

Thank you!!