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