current cell - select 5 to the right

**RxMiller** · 07-14-2010, 12:59 PM

The imported data list bolds the first item in the second column and then changes the color for the repeated items. It bolds the next change and continues...
From there, I can bold the entire column on the report.

Problem:
The customer wants me to only bold the first 8 columns, not the entire row.
Just can't figure this part out.

Please Login or Register  to view this content.

**Jbm444** · 07-14-2010, 01:07 PM

Try using resize, like this:

Please Login or Register  to view this content.

***Edit:
More specifically for your code, I think you would change the line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Or, if I interpreted correctly that you're operating in the second column, but need the first 8 columns bolded...

Please Login or Register  to view this content.

Let me know how it goes

**RxMiller** · 07-14-2010, 01:51 PM

Really, really close now! Thanks. The IF statement works just great!
Please look at the 'else' statements.
It works for the entire row, but the code for 15 columns out makes the fonts clear (or white) instead of the gray color desired.

Please Login or Register  to view this content.

**Jbm444** · 07-14-2010, 02:05 PM

I think I got it: just switch the two non-working lines.

By my tests with it, denoting themecolor has to come before denoting tintandshade.

Please Login or Register  to view this content.

**RxMiller** · 07-14-2010, 02:38 PM

WOW! how suttle.
I almost did that during my copy and paste and would have never realized that it made a difference!
Mark this one as Solved
Thanks heaps!

**Jbm444** · 07-14-2010, 02:44 PM

You're welcome. Remember, you can mark it as solved yourself by using "edit," "Go advanced," and in the "prefix" dropdown right before the title, changing it to "solved."
Also, make sure to use the scales to add to the "reputation" of those who help you out, in this thread or any other.