Mandatory cells based on data in other cells

[MarkMeister]

Hi,

I have a water check sheet at work, and I want to know if it’s possible to have a cell become mandatory after certain data has been entered in another cell.

Basically if cell a1 has data entered below a certain number (below 20 for instance) can cell a2 become mandatory to enter into?

If a1 is above a certain number (above 20 for instance) then nothing changes.

It’s an older pc running excel 2016 and vba isn’t possible. Would something like data validation work?

Thank you everyone!!

 

[mumps]

I think that you would need a macro to do what you want. Is there any reason why VBA isn't possible?