In Excel2000, I have budget templates that different areas fill in. In
one cell, we have them input sales $ and in the cell below thye input
profit %. I want to make sure that everytime they enter a sales $ they
are forced to enter a profit %. I don't want to put in a formula in the
Profit % cell because they then will input over the formula. Here is an
example:

Jan
Sales $ 100
Profit % 8%

Sometimes they forget the Profit % and it causes problems, like this:

Jan
Sales $ 100
Profit %

Anyone have any ideas on how I can insure an input?

Thanks