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!
Discussion on:
Message 23 of 23
0
Votes
cumbersome
Posted by jbenton@...
Updated - 22nd Feb
