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

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