Data Validation - Simple if you know how (I suspect)

**seftonbarn** · 12-09-2014, 10:32 AM

Cells B1:B12 are used to record values for the months Jan - Dec (where a value is applicable). Cell B13 is used as a text field to explain why B1:B12 are empty. I would like an error message to pop up when attempting to enter text into B13 unless all of B1:B12 are empty. Any hints or tips greatly received.

**sweep** · 12-09-2014, 11:11 AM

Hi,

use the following formula as custom validation

=COUNTA(B1:B12)=0

**Mazzaropi** · 12-09-2014, 11:12 AM

seftonbarn, Good afternoon.

Try to use:
=SUM(B1:B12)=0

Put it at a Custom rule of Data Validation and set up your Error Message.

Is this what you want?
Hope this helps.