View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jg jg is offline
external usenet poster
 
Posts: 42
Default Trying to validate input based upon values in two other cells

I'm trying to pop a warning message (Datavalidiation Stop) or display a text
value in another cell when two conditions exist:

Cell D4 is = 0 and cell G4 is having a numberic value entered into it.

If Cell D4 is 0 then any number can be entered into G4.