Compulsory cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have any ideas how to make a cell compulsory if the cell next to
it has been filled in?
Can't see how to do it through validation. Don't want to use VBcode as you
can disable this when opening the file.
 
I'd use a formula in another cell. Then format it in nice big, bold, red
letters:

=if(and(a1="",b1<>""),"Please put something in A1","")
 

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

Mandatory/Compulsory 2
New !! USB Stick For Seniors 1
Deleting a record when some compulsory fields not filled 3
How can i make a cell compulsory to complete? 1
COUNTIF multi criteria 2
Windows 10 Done it. 19
The BBQ Season 4
compulsory/madatory cell 1

Back
Top