Is it possible to set a condition either using conditional formatting or some
other way so that the cell displays the value in one colour if it is a keyed
value or another value if it is a formula
--
bookman