060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout
Having some problems with entering data. Symptom is when enter data in one
column, its mirror image was not showing up in different column (using:
=IF(J9="","",IF(LEN(J9)3,AV9,UPPER(AV9)))

Other intermittant symptoms: - Conditional Formating was not changing color
in either column, intermittantly.
- Delete data from 1st column & intermittant: either mirror text does not
go away, or conditional formats remained color, in changed, unchanged,
intermittant fashion.

SOME SETTINGS INCLUDE:
MEMORY: 128 MB
PAGE FILE: was set at 400MB max 800 MB, changed to automatic
OPTIONS, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10

Is there advice I can get for computer settings, in general, and to help
with this situation?

Any recommendations on Memory Utilities will be greatly appreciated. Thanks.