Data Validation

[ashleywanless]

Hi,

Does anyone know what code i can use under data validation to state that data must be present?

Thanks

 

[apgmin]

I also use required the same and usedthe following for datavalidation:

USE CUSTOM IN DATAVALIDATION AND PUT THE FOLLOWING FORMULA

=NOT(ISBLANK(F2))

Uncheck Ignore blank.

I require for the F column, you replace with the column youare using it.