Making an Excel Column Mandatory

[juniormary]

Is there any way that I can format a column in excel to call for mandatory population? I think it may have something to do with Data > Validation.... but I can't seem to get it to work right. Basically... If someone populates fields in a row... I would like them to be required to populate one of the fields with their initials. If they don't, I would like a message to pop up....

Any thoughts?

 

[juniormary]

Bump for help

 

[srizki]

Highlight the column where you want to put validation, and in custom validation put formula, =NOT(TRIM(RANGE WEHRE YOU WANT INITIAL)="")


Hope it helps.