Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation - Custom
hello community
In the Excel feature, can anybody please enlighten me on how to use the - Validation Validation Criteria Custom what is the "Custom" feature use for ? (when I select the Custom criteria, only the Formula Selection fill is activated thanks community -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation - Custom
Enter a formula to be evaluated after the user makes an entry. If the
formula evaluates to True the entry is allowed... Example: Say you require the entry in D1 to be greater than A1. Select D1 and make its validation custom formula =D1A1. Note - if A1 is empty this validation will not take effect unless you uncheck "Ignore blank". -- Jim "tikchye_oldLearner57" wrote in message ... | hello community | | In the Excel feature, can anybody please enlighten me on how to use the - | | Validation Validation Criteria Custom | | what is the "Custom" feature use for ? (when I select the Custom criteria, | only the Formula Selection fill is activated | | thanks community | -- | oldLearner57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relative cell reference in custom validation | Excel Discussion (Misc queries) | |||
Custom data validation | Excel Discussion (Misc queries) | |||
Data Validation - Custom | Excel Discussion (Misc queries) | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) |