data validation

[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

 

[J.E. McGimpsey]

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.

 

[Gord Dibben]

Spence

Data>Validation>Allow>Custom.

Type in =C1>0

Input and/or Error Message of your choice.

Gord Dibben Excel MVP - XL97 SR2 & XL2002