| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting problem
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting problem
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting problem
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting problem
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting problem | Excel Discussion (Misc queries) | |||
| Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
| Conditional Formatting Problem | Excel Discussion (Misc queries) | |||
Linear Mode
