can be replaced with
$A1 NE ""
(NE means less than followed by greater than - why can't we use these?)
unless A1 is an error, in which case you've got more problems than your formatting going awry!
Keep Up with TechRepublic