This is a good, simple answer. I didn't consider that I don't really care
whether the cell contains a formula, but rather whether the value it holds
equals the value that the formula calculates. If someone overwrites the
formula with the same value the formula calcs, I don't really need the cell
to be shaded. Thanks

Biff has a cool solution, too, and it would be cool to see if it could also
work.

"Sandy Mann" wrote:

Try something like this in Conditional Formatting:

=A5< <Your Formula

where <Your Formula is the formula in the cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"IvanM" wrote in message
...
Thanks, but this is not what I had in mind. The formulas in question
result
in values. We want to allow users to over-write a formula's value with a
different value (manually input), as appropriate. I then want any cell
where
the formula's value has been over-written to be automatically highlighted
(say with shading) so supervisors can see where manual intervention has
been
taken.

"Cimjet" wrote:

Hi YvanM
If you go to Menu Tools/Option /View/ Window Options and select Formulas
All the formulas on that sheet will show up.
Hope that helps
Cimjet
"IvanM" wrote in message
...
I want users to be able to see where they have over-written a formula
with
text or a value (don't care which). I can't find a function that
determines
whether a cell contains a formula. Is there such a function? Or is
there
some other way to accomplish this?
thanks