data validation

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

how can i assign data validation to cell A1 with a custom
formula that would say: if C1=0 then SHOW ERROR MESSAGE i
want to not be able to enter anything into A1 until the
value in C1 is greater than 0. TIA
 
Select A1, Choose Data/Validation/Custom and enter =C1>0 in the
textbox. Uncheck the Ignore blanks checkbox. Enter your error
message in the error tab.
 
Spence

Data>Validation>Allow>Custom.

Type in =C1>0

Input and/or Error Message of your choice.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top