Conditional formatting if a formula is replaced by value

  • Thread starter Thread starter mrbucc
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
can conditional formatting varry the area it highlights based on c 3
conditional formatting 1
Conditional Format based on sub-string 3
IF formula with conditional formating help please 3
Conditional Format & Default Format Help 1
Conditional Formatting Applied when Statement Not True 6
Excel 2007 - A Conditional Formatting ?'s 1

Back
Top