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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2015, 01:56 AM
dawd dawd is offline Data Validation - Prevent blank cell based on a condition Windows 7 64bit Data Validation - Prevent blank cell based on a condition Office 2010 64bit
Novice
Data Validation - Prevent blank cell based on a condition
 
Join Date: Aug 2015
Posts: 2
dawd is on a distinguished road
Default Data Validation - Prevent blank cell based on a condition

Hi,



I'm looking for a formula that will prevent entry into a cell if another cell is left blank.

The table below will illustrate my conundrum:
TypePA1F2F2G3

In this instance, the bottom 3 rows are fine, but what i want is for an error message to pop up which will disable entry of the '1' under PA because the Type column has no been filled out.

It feels like it should be an IF formula but I have not been able to get anything to work. I don't usually use Data validation so i could be looking at it from the wrong angle,

Could anyone suggest a formula that might work under the 'custom' setting in data validation?

Any help would be hugely appreciated!

Many thanks

Dan
Reply With Quote
  #2  
Old 08-12-2015, 04:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data Validation - Prevent blank cell based on a condition Windows 7 64bit Data Validation - Prevent blank cell based on a condition Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,400
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi
please post a sample sheet - Thx
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 08-12-2015, 05:44 AM
dawd dawd is offline Data Validation - Prevent blank cell based on a condition Windows 7 64bit Data Validation - Prevent blank cell based on a condition Office 2010 64bit
Novice
Data Validation - Prevent blank cell based on a condition
 
Join Date: Aug 2015
Posts: 2
dawd is on a distinguished road
Default

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
File Type: xlsx example.xlsx (9.0 KB, 1 views)
Reply With Quote
Reply

Tags
data validation

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - Prevent blank cell based on a condition 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
Data Validation - Prevent blank cell based on a condition 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


All times are GMT -7. The time now is 09:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft