Inactive cell

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

 

but if 

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

By: awais

Leave a Reply

Your email address will not be published. Required fields are marked *