Auto Fill Color Cell

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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!!
 
Copy this to general module in your workbook

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

In Format>CF>Formula is: =IsFormula(cellref)=FALSE

Format the cell(s) to yellow.


Gord Dibben MS Excel MVP
 
Back
Top