data entry validation

[angie]

i have a spreadsheet with two columns containing text data, one column
containing date data, and ten columns containing either number or currency
data. currently i only have 100 rows with data.
my goal is when i enter data in a row NOT to have blank text and date cells
and number and currency cells to have a value equal or greater than zero.
is that possible in excel?

 

[Jeff]

Try using the data validation tool. Data >> Validation

There you can set what data is allowed where.