Thread: Trying to validate input based upon values in two other cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Trying to validate input based upon values in two other cells
Data ValidationAllowCustom

=AND(D40,ISNUMBER(G4))


Gord Dibben MS Excel MVP


On Thu, 10 Dec 2009 13:23:01 -0800, JG wrote:

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.

Reply With QuoteReply With Quote