software

In my ss I have a cell say b1 with a formula in it. Under certain conditions
when this cell = another cell I have conditional formating turn the number to
red. This color change indicates that you need to enter in the correct
reading in place of the formula in the same cell. Is there a way that once
the correct number is entered in place of the formula that it will chnage
back to black. The number entered will still equal the other cell but I
thought there may be a way since the formual is missing. Thanks

Scott

Add a UDF

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

and than add that in the CF formula

=AND(IsFormula(A10),A10=3)

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;scottquot; gt; wrote in message
...
gt; In my ss I have a cell say b1 with a formula in it. Under certain
conditions
gt; when this cell = another cell I have conditional formating turn the number
to
gt; red. This color change indicates that you need to enter in the correct
gt; reading in place of the formula in the same cell. Is there a way that once
gt; the correct number is entered in place of the formula that it will chnage
gt; back to black. The number entered will still equal the other cell but I
gt; thought there may be a way since the formual is missing. Thanks
gt;
gt; Scott
Bob

I am not sure I understand. Wher do I put the formula you are suggesting

quot;Bob Phillipsquot; wrote:

gt; Add a UDF
gt;
gt; Function IsFormula(rng As Range)
gt; IsFormula = rng.HasFormula
gt; End Function
gt;
gt; and than add that in the CF formula
gt;
gt; =AND(IsFormula(A10),A10=3)
gt;
gt; as an example
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;scottquot; gt; wrote in message
gt; ...
gt; gt; In my ss I have a cell say b1 with a formula in it. Under certain
gt; conditions
gt; gt; when this cell = another cell I have conditional formating turn the number
gt; to
gt; gt; red. This color change indicates that you need to enter in the correct
gt; gt; reading in place of the formula in the same cell. Is there a way that once
gt; gt; the correct number is entered in place of the formula that it will chnage
gt; gt; back to black. The number entered will still equal the other cell but I
gt; gt; thought there may be a way since the formual is missing. Thanks
gt; gt;
gt; gt; Scott
gt;
gt;
gt;

In a code module. In Excel, Alt-F11 to the VBIDE, insert a module,
Insertgt;Module, and paste that code in. Then close the VBIDE and go back to
Excl.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;scottquot; gt; wrote in message
...
gt; Bob
gt;
gt; I am not sure I understand. Wher do I put the formula you are suggesting
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Add a UDF
gt; gt;
gt; gt; Function IsFormula(rng As Range)
gt; gt; IsFormula = rng.HasFormula
gt; gt; End Function
gt; gt;
gt; gt; and than add that in the CF formula
gt; gt;
gt; gt; =AND(IsFormula(A10),A10=3)
gt; gt;
gt; gt; as an example
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;scottquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; In my ss I have a cell say b1 with a formula in it. Under certain
gt; gt; conditions
gt; gt; gt; when this cell = another cell I have conditional formating turn the
number
gt; gt; to
gt; gt; gt; red. This color change indicates that you need to enter in the correct
gt; gt; gt; reading in place of the formula in the same cell. Is there a way that
once
gt; gt; gt; the correct number is entered in place of the formula that it will
chnage
gt; gt; gt; back to black. The number entered will still equal the other cell but
I
gt; gt; gt; thought there may be a way since the formual is missing. Thanks
gt; gt; gt;
gt; gt; gt; Scott
gt; gt;
gt; gt;
gt; gt;