Data Validation AND Formula

T

twilley259

New Member
Joined
Jan 24, 2019
Messages
16
Hello,
I have the following spreadsheet. I would like to add data validation to Row 4 to look at Cells 46 and 49. So basically what I would like to do is not allow the operator to fill out the next column of data IF cell 46 says Failed and cell 49 does not have text in it. If cell 46 says Failed, and cell 49 has a comment they can continue without issue. If cell 46 says Passed and cell 49 is blank they can continue without issue.

I want to force the operator to make comments on failed checks.

 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
You must log in or register to reply here.

Similar threads

B
  • Question Question
Auto Fill values in cells with items in Data Validation or a List/range
Replies
2
Views
337
Skyybot
Skyybot
apgmin
  • Question Question
Selective Data Validation
Replies
1
Views
158
kvsrinivasamurthy
K
R
  • Question Question
Add to Data Validation Values From Data Entry Cell
Replies
4
Views
263
kvsrinivasamurthy
K
D
  • Question Question
Can a Data Validation List be auto filtered by reference to a cell content?
Replies
1
Views
189
Joe4
Joe4
M
  • Question Question
Data Validation using VBA and Excel function
Replies
0
Views
429
ManUBlueJay
M

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

Share this page

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
Back
Top