Help "This cell must be filled before..."

jrandol

New Member
Joined
Feb 16, 2004
Messages
22
This is what I want it to do:


Cell (H2) must be filled before entering data into this cell (B3). The H2 cell is a drop down box.

Thank you for the help!
JR
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,270
For a given cell to only be enter-able if another cell is not blank:

Select cell B3, click on Data > Validation.
Select Custom from the Allow drop-down.
In the Formula field, enter the formula =LEN(H2)<>0
Deselect (uncheck) "Ignore blank".
Click on the Error Alert tab, make sure there is a checkmark next to "Show error alert after invalid data is entered".
Type in your Title and Error message, then click OK.
 

jrandol

New Member
Joined
Feb 16, 2004
Messages
22
Tom, Thank you for the help again!!! I entered it and it doesn what I want it to do.

Thanks,
JR
 

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,270
Are you saying it does or it doesn't? Maybe a typo in your post ("doesn")? It worked for me when I tested it. Post back if you're still having trouble.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,160
Messages
5,768,527
Members
425,480
Latest member
br400821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top