IBM Lotus Symphony
|
For each cell, you can define entries to be valid. Invalid entries to a cell are rejected.
![]() |
The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule does not take effect. |
![]() |
You can choose Tools - Detective at any time and choose the command Mark Invalid Data to display which cells contain invalid values. |
Select the cells for which you want to define a new validity rule.
Select
.On the Criteria tab page, enter the conditions for new values to be entered into cells.
In the Allow field, select an option.
If you select Whole numbers, values such as "12.5" are not allowed. Choosing Date allows date information both in the local date format as well as in the form of a serial date. Similarly, the Time condition permits time values such as "12:00" or serial time numbers. Text length stipulates that cells are allowed to contain text only.
Specify the allowed values. Select condition in the Data field. Enter the value allowed in the Value field.
If you select Cell
range in the Allow field, enter
a cell range such as "A1:B2" in the Source field.
Or you can click the Shrink button to temporarily
hide the tab page. Select a cell range in the sheet. Then click the Maximum button
to
go back to the Criteria tab page. The selected
cell range is in the Source field.
If you select List in the Allow field, enter numbers or strings in the Entries field. Strings and numbers can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid.
On the Input Help tab page, enter the title and the text of the tip, which will then be displayed if the cell is selected.
On the Error Alert tab page, select the action to be carried out in the event of an error.
If you select Stop as the action, invalid entries are not accepted, and the previous cell contents are retained.
Select Warning or Information to display a dialog in which the entry can either be canceled or accepted.
If you select Macro, then by using the Browse button you can specify a macro to be run in the event of an error.
To display the error message, select "Show error message when invalid values are entered".
Sample macro:
![]() |
After changing the action for a cell on the Error Alert tab page and closing the dialog with OK, you must first select another cell before the change takes effect. |