conditional formatting problem

[bookman3]

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

 

[Biff]

One way:

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

Biff

 

[bookman3]

Thanks. It worls perfectly
--
bookman

One way:

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

Biff

 

[Biff]

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

Biff