=counta(A2:F2)=0 should do that for you.

"PhilosophersSage" wrote:

That is the problem, no one column will always have text, I suppose I could
do a test for each cell, but it seems that when I test each cell not all
cells in row will receive the formatting. What has worked the best so far is :
=IF(OR(ISTEXT(A2),ISTEXT(B2),ISTEXT(C1),ISTEXT(D2) ,ISTEXT(E2),ISTEXT(F2)),
MOD(ROW(),1)=1,FALSE)

This will get multiple cells in the row, but not all of them

"Sean Timmons" wrote:

Assuming your cell in column A has text in all cases:

highlighting workbook, with cell A2 active, conditional format

=AND($A2<"",$A3="")

and format with your last row border

2nd format

=$A2<""

and format with regular border

though, from a personal perspective, seems like quite the reource to use
when you can merely highlight the workbook, remove format, highlight data set
and do formatting as needed, but guess that doesn't matter. :-)

"PhilosophersSage" wrote:

I have a spreadsheet that changes size often, and I want to conditionally
format the borders so that if a cell in a row has text the whole row gets
formatted, and the last row needs special formatting seperate from other
rows. Thank you in advance for you help!