must fill in a cell before going to next cell.

G

Guest

In Excel 2003, I need to be able to do the following:
Fix the spreadsheet so you MUST complete a particular cell before going on
to the rest of the fill-in cells. This application is a bid sheet, so certain
cells add up to a total.
 
G

Guest

Hi
Could you use data validation ?
data validation allow custom with formula =a1>0
then on error alert tab type you must enter data in cell a1 first
changing a1 to you cell
Tina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top