Macro to make multiple cells mandatory - Excel 2007

for your first question

=if(counta(C4:D6,F4:F6)<6,"wrong input","your formula")

P.s. I noticed you used merged cells.

My advice to you would be, don't use merged cells, you get in trouble with it sooner or later.

Hi,

See the attached for my usual approach to this sort of thing.

I've used helper columns I & J (which you can hide in the production workbook) to record whether the mandatory cells are complete or not. If complete then they all return zero. For additional information I've also used a conditional format so that incomplete cells are coloured light yellow.

I've named the I2 cell "Check" so all you need do in any macro is read the value of this cell and take action accordingly. e.g.

Please Login or Register  to view this content.