software

hello community

In the Excel feature, can anybody please enlighten me on how to use the -

Validation gt; Validation Criteria gt; Custom

what is the quot;Customquot; feature use for ? (when I select the Custom criteria,
only the Formula Selection fill is activated

thanks community
--
oldLearner57

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 =D1gt;A1.

Note - if A1 is empty this validation will not take effect unless you
uncheck quot;Ignore blankquot;.

--
Jim
quot;tikchye_oldLearner57quot; gt; wrote
in message ...
| hello community
|
| In the Excel feature, can anybody please enlighten me on how to use the -
|
| Validation gt; Validation Criteria gt; Custom
|
| what is the quot;Customquot; feature use for ? (when I select the Custom criteria,
| only the Formula Selection fill is activated
|
| thanks community
| --
| oldLearner57