Isn't the formula supposed to return a value? Maybe something in the
conditional formatting.

"Louise" wrote:

i am trying to enter a formula in a cell, but it is coming up as a value.
how do i change it from value to formula.
--
Louise