Valid Values
Set of possible values in which can be in the particular columns
Last updated
Set of possible values in which can be in the particular columns
Last updated
To access valid value settings click on the icon in the header of a column, then click on Valid values.
Let's show how preset values works
By clicking on Valid Values , the window will appear where you can enter the values you want to appear in between the allowed values. Add numbers 12, 15, 18, and 27 then save it.
Once you saved the values, you will see that the values in the cells that do not match have, hence they hence a red border.
If you already had values in the columns before making presets, all your cells will have red borders, so you need to choose values from the ones you made as preset or so include these values in preset/allowed.
By adding rows or columns into your rule, you have to choose values from the preset ones. You are no longer allowed to add custom values directly into cells, you have to do it in the way shown above.
