I think Data Validation might suit your needs.

Using your example....
Select cell B1
From the Excel main menu:
<data<validation
Allow: Custom
Formula: =A1

Using the defaults, that will prevent B1 entries of less than the A1 value.
Explore the other Data Validation tabs for more options.
Post back with any other questions.

Also, check Debra Dalgleish's website for more instructions:
http://www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"lawdoggy" wrote:

Hello,

I'm would like to have the data entered into one cell be copied to
another cell so the value is = that value. I hope I can explain this:

Cell A1= 100
Cell B1=needs to be 100 or greater, but i want someone to entered a
greater number if they would like. if they try to enter a number less
than A1 then they get the value of A1 again or an error box telling
them of their mistake. I'm afraid this will require some type of basic
programming? If it requires programming where does it go? in the B1?

Thanks in advance for your help!! mitch