TM1 Forum

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!

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

And what exactly did you try?

AlvinPresley wrote: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

What Ardian said should work for sure.

Assuming you can figure out where you went wrong with your conditional formatting, the easiest is to add a condition like: You would need to on which row you want the change and change the 0 in the code above accordingly.

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