Have I got a blank cell

[Paul Lautman]

=MATCH("R",range1,0) will tell me if any cell in range1 is equal to "R"
=MATCH("",range1,0) will tell me if any cell in range1 contains nothing (for
instance just a single ' )

But how do I tell if any cell in range1 is completely blank?

 

[Juan Sanchez]

This formula will tell you the relative position of the
first blank cell in "range1" if there is one, if not, it
will show an #N/A error,

=MATCH("EMPTY",IF(range1<>"",range1,"EMPTY"),0)
Is an array formula so commit with CTRL+SHFT+ENTER

You can get RID of the #N/A error by using something like
this, this will display "NO BLANK" instead of #N/A but you
can change for what ever you want...

=IF(ISERROR(MATCH("EMPTY",IF(range1<>"",
range1,"EMPTY"),0)),"NO BLANK",MATCH("EMPTY",IF
(range1<>"",range1,"EMPTY"),0))

Cheers
Juan