Description: When I want add a condition to a cell when its empty, I add the following condition: IF &Cell is equal to "" THEN [condition] a better way would be: IF &Cell is empty THEN Steps to Reproduce: Format -> Condition Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: -
(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.
(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
(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"))
When you create a condition, use relative address of the top left cell in your range. So if you selected B10:C150, the formula would be ISBLANK(B10).