#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi
please post a sample sheet - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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 |
Tags |
data validation |
|
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 |