Require an entry in a cell

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

I have 4 cells E58:E61 is there any way to mandate that one of those cells
have a value in it?
 
Erika,

Maybe, but under what condition must one of them be populated?

Mike
 
Erika,

If this isn't required for a formula then it would have to be done with code
but I still have the same question 'when does this apply'?

For example do we test as soon as the workbook is opened and not allow and
other changes to take place until the condition is satisfied or do we stop
someone closing the workbook until they populate one of these cells, or is it
something else?

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Help in Office 2007 3
Conditional format of range 3
Match worksheet Function displays wrong data on calculation 1
Formula Problem. Anyone up for the challenge, lol? 5
No duplicate records problem 34
Excell Formula 1
Changing a cell value from another cell. 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top