Bbcode for border help!

[GerryZ]

hello everybody
I like very much this ADD-ins bbcode for boarders
The only thing i would change is the columns and rows headers I would like to be coluored in red like in my sample
can some of help me?
Thank You!

Row\Col	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

<tbody>
</tbody>

 

[GerryZ]

bump!

 

[DocAElstein]

Hi Molly ( XL) ,

hello everybody
I like very much this ADD-ins bbcode for boarders
The only thing i would change is the columns and rows headers I would like to be colourerd in red like in my sample
can some of help me?
.....

… I am not the best qualified to help. But as Yous have already „Bumped“ I can fill in until Yous gat a better answer…

What BB Code ADD-in are Yous using to get that screen shot in Post # 1 ??

............... You already know about Rory’s Tools I think? – You know that his most recent one will give you this:-

Excel 2007

Row\Col	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

Sheet: Molly

. --- link I think you know already but it is in my signature below.

………………………………

. Those tools are easy to make simple modifications in to suit. For example I use regularly a couple of versions:

Using Excel 2007

-	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

Molly

...---here the modified add-in
https://app.box.com/s/oa1zouz1ksm68yevndee6yi1v1o0qmmm

…………………………………………………………..

Or this:
Using Excel 2007

Row\Col	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

Molly

. --- here the modified add-in
https://app.box.com/s/7v5no8t18qqzjwyfqtv1xo5elsyba3o6

………………………………………………………………..

. if you take a look at the codes in the various Add-ins, you should be able to do similar simple mods to obtain the output as you wish….
.. For example, I just did an Add-in Mod for you to give this:

Row\Col	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

. ---- here the modified Add-in
https://app.box.com/s/x8bqg7cil2xnqyyo07v8gwt5zpiebxta

…..
. Hope that gives you a start.

Alan Elston

P.s. 1 Remember that currently all the above Add-ins error for XL 2007 for text color other than the default ( Automatic black ).
P.s. 2 There is just recently a new BB code generator available:
Posting an HTML table in a forum thread

. – it would give you this:

Data Range

	A​	B​	C​	D​
1​	Name​	Tot​	Tot​	Tot​
2​	joe​	60​	52​	23​
3​	luis​	24​	100​	81​
4​	frank​	95​	74​	24​
5​	anna​	67​	58​	55​
6​	mike​	56​	63​	83​
7​	violet​	39​	49​	49​
8​	grace​	28​	26​	68​

. But I do not have much experience with that …. I did however just do a quick mod and can get this for you:

BigMolly

Row\Col	A​	B​	C​	D​
1​	Name​	Tot​	Tot​	Tot​
2​	joe​	60​	52​	23​
3​	luis​	24​	100​	81​
4​	frank​	95​	74​	24​
5​	anna​	67​	58​	55​
6​	mike​	56​	63​	83​
7​	violet​	39​	49​	49​
8​	grace​	28​	26​	68​

. This last one does accept colored text even for XL 2007, but it is a bit difficult to copy to a Thread. ( It is not an add-in but I did some notes to get it up and running here:
http://www.excelforum.com/the-water...-off-there-no-reply-needed-2.html#post4110298

If you want a copy, let me know and I will try to post it..

 

[DocAElstein]

..........
P.s. 1 Remember that currently all the above Add-ins error for XL 2007 for text color other than the default ( Automatic black ).
.........

Edit:

Earlier version of Forum Tools does do text colour for XL 2007 ( But not Background colour )
https://app.box.com/s/oa1zouz1ksm68yevndee6yi1v1o0qmmm

Using Excel 2007

-	A​	B​	C​	D​
1​	Name	Tot	Tot	Tot
2​	joe	60​	52​	23​
3​	luis	24​	100​	81​
4​	frank	95​	74​	24​
5​	anna	67​	58​	55​
6​	mike	56​	63​	83​
7​	violet	39​	49​	49​
8​	grace	28​	26​	68​

Molly

 

[GerryZ]

Hello
Excel 2013 error because the font color is not black
works only with black
I hope new version

 

[DocAElstein]

Hello
Excel 2013 error because the font color is not black
works only with black
I hope new version

.........

... Did you also check out all info I gave in post #3?

 

[GerryZ]

hello thank you for your help
I tried all in post# 3 but tay dont work very well, i belive because this are the new modifed add-in taht i fond in the web site excel matter, this bbcode are not very stabilize expecialy dipenge vor the versione excel PC MAC and font color,,
in the old bbcode versione I never had a problem
so I'd like to have BBcode old version like this you can see in marcelo branco post
with blu or red colomn and rows headers
you think is possible tho have the old version with
hav ea look thi thresd in nr 3
thank you
http://www.mrexcel.com/forum/excel-...plication-offsetting-resetting-each-time.html

 

[DocAElstein]

Hi Molly
. 1)

hello thank you for your help
I tried all in post# 3 but tay dont work very well, i belive because this are the new modifed add-in taht i fond in the web site excel matter, this bbcode are not very stabilize expecialy dipenge vor the versione excel PC MAC and font color,,
in the old bbcode versione I never had a problem

I gave you three add-ins to try, the last one
https://app.box.com/s/x8bqg7cil2xnqyyo07v8gwt5zpiebxta
... I modified it as you wanted it.
. It is based on the old bbcode. So I am surprised it does not work. for you?
. Remember you must download and install all the Add-ins and try them.
...............................
.2 )

........
so I'd like to have BBcode old version like this you can see in marcelo branco post
with blu or red colomn and rows headers
you think is possible tho have the old version with
hav ea look thi thresd in nr 3
thank you
http://www.mrexcel.com/forum/excel-...plication-offsetting-resetting-each-time.html

... I do not know which Add-in you are talking about. I could take a look, but you must tell me where I can find / download that version…

........................................

. 3) I also mentioned finally another code version. Maybe that is going too far for now for you?? I could post that code for you later if you wish…

Alan

 

[GerryZ]

Excel 2013

Row\Col	A​	B​
1​	Item	Dup?
2​	FAD	VERO​
3​	KAD	FALSO​
4​	FAD	VERO​
5​	ZAD	VERO​
6​	LAD	VERO​
7​	LAD	VERO​
8​	NAD	FALSO​
9​	JAD	FALSO​
10​	XAD	FALSO​
11​	ZAD	VERO​

test

Sheet: 3

 

[GerryZ]

Row\Col	A​	B​
1​	Item	Dup?
2​	FAD	VERO​
3​	KAD	FALSO​
4​	FAD	VERO​
5​	ZAD	VERO​
6​	LAD	VERO​
7​	LAD	VERO​
8​	NAD	FALSO​
9​	JAD	FALSO​
10​	XAD	FALSO​
11​	ZAD	VERO​