cell change

[George]

Is there any way to do the following without having to write VB.

If cell changes Do .....

Thanks.

 

[Paul Corrado]

George,

It depends on what you want to happen. Conditional formatting can implement
formatting changes. Formulas will recalculate. So yes, some things can be
done.


PC

 

[George]

Paul,

I need to perform a calculation in cell B1 only if the contents of cell A1
change. Do you know how this can be done without doing VB.

Thanks.

 

[Paul Corrado]

It depends on what you mean by change. If you mean every time the contents
are changed, then no, unless you manually change the formula.

ex.

In B2 you could have the formula

IF(A1="XYZ",do nothing,perform calculation) however once the contents are no
longer XYZ then it may or may not do what you want.

PC

 

[George]

Paul,

Conditional formatting doesn't have an option for "cell change". It looks
like it allows only comparison to some other value.

 

[Paul Corrado]

George,

Yes, that is correct. Conditional formatting will not react to just the
fact that a cell has been changed. I was referring to its ability to change
a cell format based on a calculation or condition.

It sounds as if you need an event macro, and I am sure someone here can
provide one directly or help with a suggestion on where you could look.

PC