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