Border every 7th row

[AlvinPresley]

Hi,

Is there anyway in which we can put a different border for every 7th row and a different border for the first 6 rows? Every 7 rows have the same rptrow value!
I've tried to use the conditional formatting in the format section but that doesnt seem to work. May be because i have another condition already on it for changing it to % or numeric value?

kindly Help!

[tomok]

I've tried to use the conditional formatting in the format section but that doesnt seem to work.

And what exactly did you try?

[ardi]

Hi,

Is there anyway in which we can put a different border for every 7th row and a different border for the first 6 rows? Every 7 rows have the same rptrow value!
I've tried to use the conditional formatting in the format section but that doesnt seem to work. May be because i have another condition already on it for changing it to % or numeric value?

kindly Help!

You can do this in the Active Form Format Area. Add a row in your format area, give it the ID you want ( for example N7 ) and apply the formatting you want for that row

Then in the first column of your Data Range, write some formula ( you can use Excel Formulas or TM1 Formulas ) that will return "N7" for the rows you want to apply that specific formatting

[deepakjain2020]

What Ardian said should work for sure.

[gtonkin]

Assuming you can figure out where you went wrong with your conditional formatting, the easiest is to add a condition like:

Code: Select all

=MOD(ROW(),7)=0

You would need to on which row you want the change and change the 0 in the code above accordingly.

[AlvinPresley]

Hello People!

Thank you for your suggestions! I had to change the entire formatting area to set things right! Thanks to Ardi..It did work..that is what i did..I was just looking for a workaround though. Anyways, figured that this way was much simpler and a straight forward approach! Thanks again!

Cheers