In many cases it is highly recommended "protect" certain cells that contain formulas or data entries that do not want to modify past neglect. Normally you use the specific tool excel protection for this work. But there is a simpler and, above all, more flexible for our purpose. This is a simple formula applied to the tool Data Validation which we shall see below.
Imagine having the following chart with sales dates:
What we seek is that Excel does not allow to change these cells containing sales or, rather, that they change excel data "we ask" if you really want to change. Namely:
1. Select the range C4: C18 and go to menu Data / Validation .
2. choose Enable / Custom and introduce the following formula: = ""
3. Activate the last tab, which is error message , and select Warning Style. On the right we can customize the warning message that we want displayed:
4 . press OK and problem solved. From the moment you change in error, for example, sales of March 2010 before proceeding to modify the cell excel will show the message that you have designed and will decide whether to continue or not:
This system is very simple and practical but it is important to note that it is intended only to overwrite errors, because if someone copies and pastes over these cells (which theoretically do not want to modify) the validation no avail.
0 comments:
Post a Comment