Home / Discussions

Reply to Message

cumbersome
NOT(ISBLANK($A1))
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!
Posted by jbenton@...
Updated - 22nd Feb