Validation - Custom

[Guest]

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

 

[Jim Rech]

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 =D1>A1.

Note - if A1 is empty this validation will not take effect unless you
uncheck "Ignore blank".

--
Jim
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