How to enter new data and change also the cell color?
Posted by Eli Weiss on September 03, 2001 1:54 AM
I am using long databases which I am updating from to time by overwriting the old data by new one.
I am looking for a way to be sure that I have swiched all the old data by the new one.
Is there any simple way to enter a new data into a cell in Excell so that it will overwrite the old data but in the same time it will change the color of the cell to a specified color (e.g. yellow), which will indicate that new data has been entered?
A simple and interactive way will be appreciated.