check cell
 

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

check cell
 

data validation can help you here.You can put in a message which will ask
them to input a margin when they select a cell,and even stop them from
inputting a value in sales wthout a value in margin.Of course then they can
put a value in margin and no value in sales.You cant force them to input
values in both.(Well a user form or macro could)
check it out
The formula that yiou would use is a custom =E13<""
this of course assumes the profit margin input cell is e13

--
paul

remove nospam for email addy!



"snax500" wrote:

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

check cell
 

Hi snax500,

One way to ensure input is to have a formula which highlights when the
profit percentage hasn't been entered. This can be as "loud" as you
choose (using red colour, bold, large font, etc) and disappears when
the profit percentage is entered.

eg If sales are entered in C3 and Profit percentage is entered in C4,
then in say C5 you can enter:
=IF(C3="","",IF(C4="","*** Please enter Profit percentage ***",""))
Then format C5 with noticeable fonts.

snax500 Wrote:

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



--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532758