View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott04 scott04 is offline
external usenet poster
 
Posts: 3
Default 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.