https://bugs.documentfoundation.org/show_bug.cgi?id=150904
--- Comment #3 from Kurosh Tavassoli <[email protected]> --- (In reply to Kurosh Tavassoli from comment #2) > (In reply to Mike Kaganski from comment #1) > > (In reply to Kurosh Tavassoli from comment #0) > > > When I want add a condition to a cell when its empty, I add the following > > > condition: > > > > > > IF &Cell is equal to "" THEN [condition] > > > > Not exactly. It is not "&Cell", but "Cell value" - and that is really > > important. Empty cell does *not* have a value at all, so you can't check > > what its value is. > > > > Instead, use "Formula is", and use ISEMPTY(cell), which expresses the > > intention explicitly. > > > > IMO, it has no reason to try to add another option to the drop-down for > > every thinkable condition (which is impossible). The existence of formula > > condition gives user everything required to construct any condition they > > need. > > Yes, I totally agree. Thanks Excuse me, after thinking for a while I'm still confused. I want to color empty cells(In reply to Kurosh Tavassoli from comment #2) > (In reply to Mike Kaganski from comment #1) > > (In reply to Kurosh Tavassoli from comment #0) > > > When I want add a condition to a cell when its empty, I add the following > > > condition: > > > > > > IF &Cell is equal to "" THEN [condition] > > > > Not exactly. It is not "&Cell", but "Cell value" - and that is really > > important. Empty cell does *not* have a value at all, so you can't check > > what its value is. > > > > Instead, use "Formula is", and use ISEMPTY(cell), which expresses the > > intention explicitly. > > > > IMO, it has no reason to try to add another option to the drop-down for > > every thinkable condition (which is impossible). The existence of formula > > condition gives user everything required to construct any condition they > > need. > > Yes, I totally agree. Thanks Excuse me, I can't figure a way out for doing so. I want to add a condition to color all empty cells in my sheet. This is the best idea that crossed my mind: FORMULA IS: ISBLANK(CELL("ADDRESS")) -- You are receiving this mail because: You are the assignee for the bug.
