HSHO
HSHO

Reputation: 525

Reject input if the adjacent cell is empty

Using below formula to Reject input if the adjacent cell is empty.

I am trying to made the condition for the Data validation rules that if R2:R500 is empty then Column M will Reject the input when try to add anything but below formula is not working in Validation.

=NOT(ISBLANK(R24))

Here is my Sheet

Upvotes: 0

Views: 953

Answers (1)

Harun24hr
Harun24hr

Reputation: 36840

Try this validation setup.

=$R2:$R500<>""

enter image description here

Upvotes: 2

Related Questions