Delting contents of cell, if another equal a certain value...

[soltek]

I have a drop-down list with various descriptions of an order, and i
thie description equals "CANCELLED", i would like another cell to b
cleared or deleted of contents. Can this be done without macro or VB?
Or can it just be done period? Thanks in advance

 

[Frank Kabel]

Hi
to clear a different cell without macros is not possible

 

[Guest]

Guess K's solution showed you eh?? ...

-----Original Message-----
Hi
to clear a different cell without macros is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

without macro or
VB?

.

 

[Frank Kabel]

One can argue if this deletes a different cell. But as long as the OP
is happy with this solution

 

[kkknie]

No need to argue here. It definately doesn't delete anything, but
figured that making it not show up would be OK. Hopefully it is jus
for display/printing purposes...

 

[Gord Dibben]

anonymous

The cell is not "cleared" or "deleted of contents", just looks blank, so no
one got "showed" anything.

If you're going to make smartass comments about others, at least have the
balls to use a name.

Gord Dibben Excel MVP