Validation with null value
 

Hi everyone,
I have a spreadsheet that i am need of assistance. Column H has data
validation with states Yes or No. I am trying to figure out the formula that
states for example if H4 = Yes then K4 cannot be null and have a message box
pop up. I know how to do this in Access but am not sure how this can simply
be accomplished in Excel. Thank you.