ExcelBanter - Can I use validation?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I use validation? (https://www.excelbanter.com/excel-discussion-misc-queries/132569-can-i-use-validation.html)

jimmc

Can I use validation?

I have a cell that I would like to have the user input a value to if
another condition on the workheet is met. If the condition is not me,
I would like to have that cell populated with a 0 and possibly have
the cell protected from entry. Is this possible? Can I use a custom
validation formula?

All times are GMT +1. The time now is 04:11 AM.