Trying to validate input based upon values in two other cells

[JG]

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.

 

[Gord Dibben]

Data Validation>Allow>Custom

=AND(D4>0,ISNUMBER(G4))


Gord Dibben MS Excel MVP