Forum Discussion
Conditional format cells in spilled ranges as formulas
Your formula doesn't make the cell blank, it returns empty string. So far in Excel formulas don't return blank as a value.
Thus if the purpose is to color all cells with any value, includes empty string, you may apply rule like
=ISTEXT(N5) + (LEN(N5)>0)
Your formula doesn't make the cell blank, it returns empty string. So far in Excel formulas don't return blank as a value.
Thus if the purpose is to color all cells with any value, includes empty string, you may apply rule like
=ISTEXT(N5) + (LEN(N5)>0)
SergeiBaklan that absolutely did the trick! Will have to remember this. So any cell that is text, and any cell that has text (because that is how Excel reads it/what I tell Excel to output with "") with a length of 0 characters ("") - correct?
I'd say any cell with any value except empty string (len>0) OR empty strings (for it len=0 but it's the text )
