Conditional formatting if a formula is replaced by value
 

I would like to set up a conditional formatting in case a cell is changed
from a formula to a text value. I can protect the cells is an option but
there are times when I will change the formula to a text but I would like to
highlight yellow.

Conditional formatting if a formula is replaced by value
 

On Apr 9, 9:18 am, mrbucc wrote:
I would like to set up a conditional formatting in case a cell is changed
from a formula to a text value. I can protect the cells is an option but
there are times when I will change the formula to a text but I would like to
highlight yellow.

Perhaps this User Defined Function could be used in the "Formula Is"
part of the conditional formatting...

Public Function NowText(Cell As Range) As Boolean
NowText = Not Cell.HasFormula
End Function

Ken Johnson