Excel show warning message when skipping and let row cells empty

[handri]

hi

i have cell A6:A20 . I will fill data downward into each cell from A6 to A20.
If someone are skipping row by entering the key button and let the cell empty (eg skip A7 and fill A8). Is there any way to stop and warn message like "YOU MUST FILL THIS CELL" and stop operation like data validation do.

thank you

 

[Peter_SSs]

Data Validation can be defeated if users copy/paste data but if this is just a reminder to the user who might accidentally skip one or more cells, then you can use Data Validation.
Select A6:A20 and in Data Validation, Allow: Custom, Formula: =COUNTBLANK(A$6:A6)=0, OK

 

[handri]

Data Validation can be defeated if users copy/paste data but if this is just a reminder to the user who might accidentally skip one or more cells, then you can use Data Validation.
Select A6:A20 and in Data Validation, Allow: Custom, Formula: =COUNTBLANK(A$6:A6)=0, OK

thanks Peter

There is data validation before in the cell. Do we apply 2 times?

 

[Peter_SSs]

thanks Peter

There is data validation before in the cell. Do we apply 2 times?

Probably not.
What sort of values are you entering in the cells & what DV do you already have in the range?

 

[handri]

I meant that is it able to combine formula?

thanks

 

[handri]

this is my formula exsited

=COUNTIF($A$6:$A$1000,A6)=1

 

[Peter_SSs]

this is my formula exsited

=COUNTIF($A$6:$A$1000,A6)=1

OK, so try (in DV)
=AND(COUNTIF($A$6:$A$1000,A6)=1,COUNTBLANK(A$6:A6)=0)

 

[handri]

OK, so try (in DV)
=AND(COUNTIF($A$6:$A$1000,A6)=1,COUNTBLANK(A$6:A6)=0)

SOLVED!!

Thanks peter, its works!!

 

[Peter_SSs]

SOLVED!!

Thanks peter, its works!!

You are welcome.