Hi Spencer, in col A, I have as you've seen, an array formula that is copied down to row 29. I also have CF in A4 set as ISTEXT(A4)´, then draw a border. If I format paint that down to row 29, every cell shows a border. In Col C, I have a few rows of text. I format painted from A4 into C4 and down to C29 and only the cells with text have a border. Does this make sense?