Conditional formatting if a formula is replaced by value

M

mrbucc

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.
 
K

Ken Johnson

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.
Click to expand...

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
 
Top