Forum Discussion
Solved
Conditional format cells in spilled ranges as formulas
Hi! I recently learned that I can conditionally format a range by using the formula =ISFORMULA(topLeftCellOfRange), though, I also then learned it doesn't work on spilled ranges, like when spilli...
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 )