Excel help needed

[harish_r_prabhu]

Hi,

I am a new excel user and would appreciate any help on the following:

In the active sheet of an excel workbook I want all cells of a column,
lets say A, to have default value of '0'.

Also, when someone is changing the value of a cell in this column,
if the new value entered is 'less than or equal to' the existing value
in the cell, the newly entered value should be rejected.

How can this be done?

thanks,
rh

 

[ray]

Look into data valadation

 

[Dave Peterson]

For some nice notes about data|validation, you can visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html