Try using the data validation tool. Data Validation

There you can set what data is allowed where.

"angie" wrote:

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?