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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,282
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,282
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.
 

Forum statistics

Threads
1,186,160
Messages
5,956,266
Members
438,244
Latest member
gaelen

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