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

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

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, 7 views)