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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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
168
Skyybot
Skyybot
apgmin
  • Question Question
Selective Data Validation
Replies
1
Views
143
kvsrinivasamurthy
K
M
  • Question Question
Data Validation using VBA and Excel function
Replies
0
Views
308
ManUBlueJay
M
M
  • Solved
Input box triggered when specific value selected from data validation list.
Replies
5
Views
282
Peter_SSs
Peter_SSs
trishcollins
  • Question Question
VBA to return the offset formula used in the data validation source
Replies
1
Views
357
Jeffrey Mahoney
Jeffrey Mahoney

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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