Data Validation - Prevent blank cell based on a condition

		Microsoft Office Forums > Microsoft Excel > Excel
Data Validation - Prevent blank cell based on a condition

FAQ

Thread Tools

Display Modes

08-12-2015, 05:44 AM

dawd

Windows 7 64bit Data Validation - Prevent blank cell based on a condition

Office 2010 64bit

Novice

Join Date: Aug 2015

Posts: 2

Sorry the paste of the table didn't work, please see the file attached

I don't want anything to be able to be input into the yellow cell, unless there is an entry in the red cell

Attached Files

example.xlsx (9.0 KB, 9 views)

Tags

data validation

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation List based on Two Named Ranges	Rich18144	Excel	4	01-14-2016 04:37 AM
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
How to create a data validation based on another cell's value??	cfreezy	Excel	1	06-18-2015 09:51 AM
Restrict data validation based upon a cell value	Strategic	Excel	2	01-27-2015 02:13 AM
Copying data from one cell to another where condition is third cell	fairyca	Excel	4	03-30-2014 08:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:57 PM.