I cannot figure this out no matter what I do
Every formula it try to apply addresses the RESULT of the formula (as
it should) instead of the value.

any solution much appreciated

thanks

First enter this small UDF:

Function formulaa(r As Range) As Integer
formulaa = 1
If r.HasFormula Then
formulaa = 2
End If
End Function


The UDF tells you if a cell has a formula in it or just a value. For
example if A1 contains 3 then
=formulaa(A1) will display 1

If A1 contains
=1+2
then formulaa(A1) will display a 2

To set the Conditional Format for Z100:

Format > Conditional Formatting... > Formula is
=formulaa(Z100)=2
and pick a distinctive format
--
Gary''s Student - gsnu200739


"Finny388" wrote:

> I cannot figure this out no matter what I do
> Every formula it try to apply addresses the RESULT of the formula (as
> it should) instead of the value.
>
> any solution much appreciated
>
> thanks
>
>

On Aug 24, 1:40 pm, Finny388 <finny...@yahoo.com> wrote:
> I cannot figure this out no matter what I do
> Every formula it try to apply addresses the RESULT of the formula (as
> it should) instead of the value.
>
> any solution much appreciated
>
> thanks

Any help would be great. I need a way to highlight a cell if a text
value has replaced the formula - to know alert this value is not the
formula's doing but the users.

Because either a value or the result of a formula is valid, it is just
very important to make them visually distinct.

thanks

On Aug 25, 11:24 am, Finny388 <finny...@yahoo.com> wrote:
> On Aug 24, 1:40 pm, Finny388 <finny...@yahoo.com> wrote:
>
> > I cannot figure this out no matter what I do
> > Every formula it try to apply addresses the RESULT of the formula (as
> > it should) instead of the value.
>
> > any solution much appreciated
>
> > thanks
>
> Any help would be great. I need a way to highlight a cell if a text
> value has replaced the formula - to know alert this value is not the
> formula's doing but the users.
>
> Because either a value or the result of a formula is valid, it is just
> very important to make them visually distinct.
>
> thanks

^

On Aug 27, 9:19 am, Finny388 <finny...@yahoo.com> wrote:
> On Aug 25, 11:24 am, Finny388 <finny...@yahoo.com> wrote:
>
>
>
> > On Aug 24, 1:40 pm, Finny388 <finny...@yahoo.com> wrote:
>
> > > I cannot figure this out no matter what I do
> > > Every formula it try to apply addresses the RESULT of the formula (as
> > > it should) instead of the value.
>
> > > any solution much appreciated
>
> > > thanks
>
> > Any help would be great. I need a way to highlight a cell if a text
> > value has replaced the formula - to know alert this value is not the
> > formula's doing but the users.
>
> > Because either a value or the result of a formula is valid, it is just
> > very important to make them visually distinct.
>
> > thanks
>
> ^

Impossible?

On Aug 27, 12:29 pm, Finny388 <finny...@yahoo.com> wrote:
> On Aug 27, 9:19 am, Finny388 <finny...@yahoo.com> wrote:
>
>
>
> > On Aug 25, 11:24 am, Finny388 <finny...@yahoo.com> wrote:
>
> > > On Aug 24, 1:40 pm, Finny388 <finny...@yahoo.com> wrote:
>
> > > > I cannot figure this out no matter what I do
> > > > Every formula it try to apply addresses the RESULT of the formula (as
> > > > it should) instead of the value.
>
> > > > any solution much appreciated
>
> > > > thanks
>
> > > Any help would be great. I need a way to highlight a cell if a text
> > > value has replaced the formula - to know alert this value is not the
> > > formula's doing but the users.
>
> > > Because either a value or the result of a formula is valid, it is just
> > > very important to make them visually distinct.
>
> > > thanks
>
> > ^
>
> Impossible?

bump

On Aug 29, 2:44 pm, Finny388 <finny...@yahoo.com> wrote:
> On Aug 27, 12:29 pm, Finny388 <finny...@yahoo.com> wrote:
>
>
>
> > On Aug 27, 9:19 am, Finny388 <finny...@yahoo.com> wrote:
>
> > > On Aug 25, 11:24 am, Finny388 <finny...@yahoo.com> wrote:
>
> > > > On Aug 24, 1:40 pm, Finny388 <finny...@yahoo.com> wrote:
>
> > > > > I cannot figure this out no matter what I do
> > > > > Every formula it try to apply addresses the RESULT of the formula (as
> > > > > it should) instead of the value.
>
> > > > > any solution much appreciated
>
> > > > > thanks
>
> > > > Any help would be great. I need a way to highlight a cell if a text
> > > > value has replaced the formula - to know alert this value is not the
> > > > formula's doing but the users.
>
> > > > Because either a value or the result of a formula is valid, it is just
> > > > very important to make them visually distinct.
>
> > > > thanks
>
> > > ^
>
> > Impossible?
>
> bump

bump

You need to add a user defined function to the workbook.

Enter this in a module:

Public Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

Then highlight the cells needing CF, go to Conditional Formatting,
choose "Formula Is" and type in the formula field:

=IsFormula(A1)

....and set your desired format.

(Change A1 in the formula to the upper-left cell of the range you
highlighted.)

Mark Lincoln


On Aug 24, 2:40 pm, Finny388 <finny...@yahoo.com> wrote:
> I cannot figure this out no matter what I do
> Every formula it try to apply addresses the RESULT of the formula (as
> it should) instead of the value.
>
> any solution much appreciated
>
> thanks

On Aug 30, 11:28 am, Mark Lincoln <mlinc...@earthlink.net> wrote:
> You need to add a user defined function to the workbook.
>
> Enter this in a module:
>
> Public Function IsFormula(rng As Range)
> IsFormula = rng.HasFormula
> End Function
>
> Then highlight the cells needing CF, go to Conditional Formatting,
> choose "Formula Is" and type in the formula field:
>
> =IsFormula(A1)
>
> ...and set your desired format.
>
> (Change A1 in the formula to the upper-left cell of the range you
> highlighted.)
>
> Mark Lincoln
>
> On Aug 24, 2:40 pm, Finny388 <finny...@yahoo.com> wrote:
>
> > I cannot figure this out no matter what I do
> > Every formula it try to apply addresses the RESULT of the formula (as
> > it should) instead of the value.
>
> > any solution much appreciated
>
> > thanks

Thank you so much! That has been an issue for so long.

Thanks!