You're welcome! We can thank JWalk for posting that on his site. That's a
relatively unknown method.

Biff

"bookman3" wrote in message
...
Thanks. It worls perfectly
--
bookman


"Biff" wrote:

One way:

http://www.j-walk.com/ss/excel/usertips/tip045.htm

Biff

"bookman3" wrote in message
...
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