Microsoft Excel - Excel 2010, date validation or conditioning or macros

Hi,

I'm not really sure what I need to do hence the title, I am working on a spreadsheet that has both free form and drop down lists. But I require something that once the first cell has been completed the ones thereafter in that row cannot be left blank. I ideally would like a pop up box to appear. If anyone can suggest anything..... :)

Nik,

Conditional formatting is pretty easy here, but would only be a reminder to the user to fill in the highlited cells
using two arguments I beleive that if you format cell 2 to be "red" when cell one has data or a value greater than 0, then have cell 2 turn back clear when it has value greater than 0.  you could in effect remind the user that you need to put data in a cell before you move on.  I have attached a file to show you what I am talking about

formatting.zip

Don

Hello Nik,

I could envisage a worksheet change macro that opens a user form for entering the data for the current row that requires all fields to be filled before allowing the user to exit.

Regards

Harry

Hello again Nik,

Perhaps you can modify this to suit your needs.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=364

Regards

Harry

Hello Nik,

This file has a version of what I think you might want to do.

data_entry_c.zip

It's still a bit buggy but hopefully you will be able to adapt it to your purposes.

Regards

Harry