Is there a way to create a code that will automatically shade a cell yellow
when someone overwrites a formula with a hard number?

Please help,

Steve

http://www.j-walk.com/SS/excel/usertips/tip045.htm

Regards,
Ryan---


--
RyGuy


"Steve" wrote:

> Is there a way to create a code that will automatically shade a cell yellow
> when someone overwrites a formula with a hard number?
>
> Please help,
>
> Steve

One way. Put this in a REGULAR module. Then use conditional formatting
=hf(h2)
Of course, that will also color text.

Function hf(x)
hf = x.HasFormula
End Function

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Steve" <(E-Mail Removed)> wrote in message
news:569B6E39-A31B-46AB-AE26-(E-Mail Removed)...
> Is there a way to create a code that will automatically shade a cell
> yellow
> when someone overwrites a formula with a hard number?
>
> Please help,
>
> Steve

Don,

I am having trouble getting this to work? Can you better explain how to do
this?
I am using Excel 2003 is it possible that this version of excel does not
have these capabilities?

Please advise. Thank you,

Steve

"Don Guillett" wrote:

> One way. Put this in a REGULAR module. Then use conditional formatting
> =hf(h2)
> Of course, that will also color text.
>
> Function hf(x)
> hf = x.HasFormula
> End Function
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Steve" <(E-Mail Removed)> wrote in message
> news:569B6E39-A31B-46AB-AE26-(E-Mail Removed)...
> > Is there a way to create a code that will automatically shade a cell
> > yellow
> > when someone overwrites a formula with a hard number?
> >
> > Please help,
> >
> > Steve
>
>

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

=========
After you get Don's code into that general module, you can use
format|Conditional formatting

Formula is:
=hf(h2)
(change H2 to the actual cell that's active)

Steve wrote:
>
> Don,
>
> I am having trouble getting this to work? Can you better explain how to do
> this?
> I am using Excel 2003 is it possible that this version of excel does not
> have these capabilities?
>
> Please advise. Thank you,
>
> Steve
>
> "Don Guillett" wrote:
>
> > One way. Put this in a REGULAR module. Then use conditional formatting
> > =hf(h2)
> > Of course, that will also color text.
> >
> > Function hf(x)
> > hf = x.HasFormula
> > End Function
> >
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > (E-Mail Removed)
> > "Steve" <(E-Mail Removed)> wrote in message
> > news:569B6E39-A31B-46AB-AE26-(E-Mail Removed)...
> > > Is there a way to create a code that will automatically shade a cell
> > > yellow
> > > when someone overwrites a formula with a hard number?
> > >
> > > Please help,
> > >
> > > Steve
> >
> >

--

Dave Peterson