Error/Warning Message for Null Cells
 

Is it possible to add validation to a cell such that if it is null an
error/warning message appears? The cell should allow any value to be
entered, it just can't be null.

Thanks!

I don't think so via Data|Validation.

But maybe you could just use an adjacent cell (formatted in nice big bold red
letters):

=if(a1<"","","<-- This cell cannot be empty")



Spyder wrote:

Is it possible to add validation to a cell such that if it is null an
error/warning message appears? The cell should allow any value to be
entered, it just can't be null.

Thanks!

--

Dave Peterson

Hi

you can't do it via data / validation - as this only works when someone
enters something into the cell - you could however, put code against a
worksheet_selectionchange, workbook_beforeprint or workbook_beforeclose
event - which ever is the most appropriate that doesn't let them select
another sheet / print or close the workbook without data in a specific
place.
If you'ld like additional information on how to this, please nominate an
event and the cell(s) you want to check.

Cheers
JulieD

"Spyder" wrote in message
...
Is it possible to add validation to a cell such that if it is null an
error/warning message appears? The cell should allow any value to be
entered, it just can't be null.

Thanks!