Is there a way to use data validation on a cell with a formula?
For example, if on cell: A1
I use: Data Validation, Criteria: Allow: Custom, Formula: A1>0
A formula like this will error as an “Invalid value”:
But a numerical entry will work:
How can this be fixed?