I have a workseet
In Cell F7 I have Total Population size
In Cell H7 I have Total Sample size
on H7 i have applied data validation as “value in H7 cannot be greater than F7”
if value in F7 is 4 then user cannnot input 5 or more in cell H7
user put bigger value in H7 before inputting any value in F7 excel allows it.
Now i need, how i can i remain inactive H7 till user give a value in F7.
if F7 is empty then user could not give any value to H7
please help in this regard