ExcelBanter - making cells mandatory entry?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - making cells mandatory entry? (https://www.excelbanter.com/excel-programming/390932-making-cells-mandatory-entry.html)

NANGO

making cells mandatory entry?

Is there a way to make filling out a cell mandatory in an excel template form?

Dave Peterson

making cells mandatory entry?

I like to use an adjacent cell that's formatted in big bold red letters:

=if(a1="","","Please fill in A1!")

NANGO wrote:

Is there a way to make filling out a cell mandatory in an excel template form?

--

Dave Peterson

All times are GMT +1. The time now is 10:32 PM.