Conditional formatting if a formula is replaced by value

's Computer Specifications

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.

's Computer Specifications

On Apr 9, 9:18 am, mrbucc <mrb...@discussions.microsoft.com> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Formula	Missile	Microsoft Excel Misc	6	24th May 2010 08:09 AM
how do i set up a formula in conditional formatting	veena	Microsoft Excel Misc	5	31st Mar 2009 11:00 PM
Conditional Formatting Formula	=?Utf-8?B?R2Vvcmdl?=	Microsoft Excel Worksheet Functions	1	28th Mar 2006 04:50 PM
How do I do a complex conditional in a conditional formatting formula	Ray Stevens	Microsoft Excel Discussion	7	12th Mar 2006 10:24 PM
Excel Formula - IF Formula & Conditional Formatting	rhhince	Microsoft Excel Worksheet Functions	1	20th Jun 2004 06:34 PM