Hello,

I have a cell (B1) that is using data validation to a named list.
I want to also put a condition on the cell (B1) that if a particular other
cell (A1) is empty, then this cell (B1) is empty too. But, the data
validation won't let me put a forumula into the cell (B1).

How can I put a formula into a cell that is 'protected' by data validation?

Thanks!