On May 31, 3:50 am, "Sam via OfficeKB.com" <u4102@uwe wrote:
Hi Kostis,

Thank you so much for your help. Your Formula does the job Great!

I just needed to tweak it so the first bottom border line was drawn on
exactly the 10th (LAST) row from the bottom /end of my dynamic range. Works
Well - Thank you.

revised:

=AND(MOD(ROW(),10)=MOD(ROWS(Data)+1,10),ROW()<=RO WS(Data)+1)

original:

=AND(MOD(ROW(),10)=MOD(ROWS(Data),10),ROW()<=ROWS (Data)-10)

Cheers,
Sam

vezeridwrote:
Sam,
the formula I gave you works from the bottom and up. I tested it.
Apparently I misunderstood your requirement and CF is now applied to
the LAST row, then LAST-10, etc. What you want is, if I understand
correctly, if your last data is in A899 then you want A889, A879 etc
to be bordered.
The CF formulas you need do not seem to be affected by your dynamic
range. Of course you can use ROWS(Data) instead of COUNTA(A:A)-1 but
that's about it. Apart from this you have to deal with MOD. I slightly
modified the formula to first format the 10th last row.
=AND(MOD(ROW(),10)=MOD(ROWS(Data),10),ROW()<=ROWS (Data)-10)
HTH
Kostis

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200705/1

Sam,
Glad it worked.

Kostis