Bbcode for border help!

GerryZ

Well-known Member
Joined
Jul 4, 2014
Messages
1,224
Office Version
  1. 365
Platform
  1. Windows
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!


[TABLE="class: cms_table_grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]
A
[/TD]
[TD]
B
[/TD]
[TD]
C
[/TD]
[TD]
D
[/TD]
[/TR]
[TR]
[TD]
1
[/TD]
[TD]Name[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[/TR]
[TR]
[TD]
2
[/TD]
[TD]joe[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR]
[TD]
3
[/TD]
[TD]luis[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR]
[TD]
4
[/TD]
[TD]frank[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR]
[TD]
5
[/TD]
[TD]anna[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR]
[TD]
6
[/TD]
[TD]mike[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR]
[TD]
7
[/TD]
[TD]violet[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR]
[TD]
8
[/TD]
[TD]grace[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
</tbody>[/TABLE]

 
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
[TABLE="class: head"]
[TR="bgcolor: #888888"]
[TH]Row\Col[/TH]
[TH]
A
[/TH]
[TH]
B
[/TH]
[TH]
C
[/TH]
[TH]
D
[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
1
[/TD]
[TD]Name[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
2
[/TD]
[TD]joe[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
3
[/TD]
[TD]luis[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
4
[/TD]
[TD]frank[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
5
[/TD]
[TD]anna[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
6
[/TD]
[TD]mike[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
7
[/TD]
[TD]violet[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]
8
[/TD]
[TD]grace[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
[/TABLE]
[TABLE="class: grid"]
[TR]
[TD]Sheet: Molly[/TD]
[/TR]
[/TABLE]
. --- 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
[TABLE="class: grid"]
[TR]
[TD]-[/TD]
[TD]
A
[/TD]
[TD]
B
[/TD]
[TD]
C
[/TD]
[TD]
D
[/TD]
[/TR]
[TR]
[TD]
1
[/TD]
[TD]Name[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[/TR]
[TR]
[TD]
2
[/TD]
[TD]joe[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR]
[TD]
3
[/TD]
[TD]luis[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR]
[TD]
4
[/TD]
[TD]frank[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR]
[TD]
5
[/TD]
[TD]anna[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR]
[TD]
6
[/TD]
[TD]mike[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR]
[TD]
7
[/TD]
[TD]violet[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR]
[TD]
8
[/TD]
[TD]grace[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
[/TABLE]
[TABLE="class: grid"]
[TR]
[TD]Molly[/TD]
[/TR]
[/TABLE]

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

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

Or this:
Using Excel 2007
[TABLE="class: head"]
[TR="bgcolor: skyblue"]
[TH]Row\Col[/TH]
[TH]
A
[/TH]
[TH]
B
[/TH]
[TH]
C
[/TH]
[TH]
D
[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
1
[/TD]
[TD]Name[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
2
[/TD]
[TD]joe[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
3
[/TD]
[TD]luis[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
4
[/TD]
[TD]frank[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
5
[/TD]
[TD]anna[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
6
[/TD]
[TD]mike[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
7
[/TD]
[TD]violet[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: skyblue"]
8
[/TD]
[TD]grace[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
[/TABLE]
[TABLE="class: grid"]
[TR]
[TD]Molly[/TD]
[/TR]
[/TABLE]
. --- 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:

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


. ---- 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
[TABLE="class: grid"]
[TR]
[TD][/TD]
[TD]
A
[/TD]
[TD]
B
[/TD]
[TD]
C
[/TD]
[TD]
D
[/TD]
[/TR]
[TR]
[TD]
1
[/TD]
[TD]
Name​
[/TD]
[TD]
Tot​
[/TD]
[TD]
Tot​
[/TD]
[TD]
Tot​
[/TD]
[/TR]
[TR]
[TD]
2
[/TD]
[TD]
joe​
[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR]
[TD]
3
[/TD]
[TD]
luis​
[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR]
[TD]
4
[/TD]
[TD]
frank​
[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR]
[TD]
5
[/TD]
[TD]
anna​
[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR]
[TD]
6
[/TD]
[TD]
mike​
[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR]
[TD]
7
[/TD]
[TD]
violet​
[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR]
[TD]
8
[/TD]
[TD]
grace​
[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
[/TABLE]

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

BigMolly
[TABLE="class: grid"]
[TR]
[TD]Row\Col[/TD]
[TD]
A
[/TD]
[TD]
B
[/TD]
[TD]
C
[/TD]
[TD]
D
[/TD]
[/TR]
[TR]
[TD]
1
[/TD]
[TD]
Name​
[/TD]
[TD]
Tot​
[/TD]
[TD]
Tot​
[/TD]
[TD]
Tot​
[/TD]
[/TR]
[TR]
[TD]
2
[/TD]
[TD]
joe​
[/TD]
[TD]
60​
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR]
[TD]
3
[/TD]
[TD]
luis​
[/TD]
[TD]
24​
[/TD]
[TD]
100​
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR]
[TD]
4
[/TD]
[TD]
frank​
[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR]
[TD]
5
[/TD]
[TD]
anna​
[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR]
[TD]
6
[/TD]
[TD]
mike​
[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR]
[TD]
7
[/TD]
[TD]
violet​
[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR]
[TD]
8
[/TD]
[TD]
grace​
[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68​
[/TD]
[/TR]
[/TABLE]



. 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..
 
Last edited:
..........
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
[TABLE="class: grid"]
[TR]
[TD]-[/TD]
[TD]
A
[/TD]
[TD]
B
[/TD]
[TD]
C
[/TD]
[TD]
D
[/TD]
[/TR]
[TR]
[TD]
1
[/TD]
[TD]Name[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[TD]Tot[/TD]
[/TR]
[TR]
[TD]
2
[/TD]
[TD]joe[/TD]
[TD]
60
[/TD]
[TD]
52​
[/TD]
[TD]
23​
[/TD]
[/TR]
[TR]
[TD]
3
[/TD]
[TD]luis[/TD]
[TD]
24​
[/TD]
[TD]
100
[/TD]
[TD]
81​
[/TD]
[/TR]
[TR]
[TD]
4
[/TD]
[TD]frank[/TD]
[TD]
95​
[/TD]
[TD]
74​
[/TD]
[TD]
24
[/TD]
[/TR]
[TR]
[TD]
5
[/TD]
[TD]anna[/TD]
[TD]
67​
[/TD]
[TD]
58​
[/TD]
[TD]
55​
[/TD]
[/TR]
[TR]
[TD]
6
[/TD]
[TD]mike[/TD]
[TD]
56​
[/TD]
[TD]
63​
[/TD]
[TD]
83​
[/TD]
[/TR]
[TR]
[TD]
7
[/TD]
[TD]violet[/TD]
[TD]
39​
[/TD]
[TD]
49​
[/TD]
[TD]
49​
[/TD]
[/TR]
[TR]
[TD]
8
[/TD]
[TD]grace[/TD]
[TD]
28​
[/TD]
[TD]
26​
[/TD]
[TD]
68
[/TD]
[/TR]
[/TABLE]
[TABLE="class: grid"]
[TR]
[TD]Molly[/TD]
[/TR]
[/TABLE]
 
Last edited:
Hello
Excel 2013 error because the font color is not black
works only with black
I hope new version

a3nIQOp.jpg
 
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
 
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
 
Excel 2013
[Table="width:, class:head"][tr=bgcolor:#888888][th]Row\Col[/th][th]
A
[/th][th]
B
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
1
[/td][td]Item[/td][td]Dup?[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
2
[/td][td]FAD[/td][td]
VERO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
3
[/td][td]KAD[/td][td]
FALSO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
4
[/td][td]FAD[/td][td]
VERO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
5
[/td][td]ZAD[/td][td]
VERO​
[/td][/tr]



test

[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
6
[/td][td]LAD[/td][td]
VERO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
7
[/td][td]LAD[/td][td]
VERO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
8
[/td][td]NAD[/td][td]
FALSO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
9
[/td][td]JAD[/td][td]
FALSO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
10
[/td][td]XAD[/td][td]
FALSO​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]
11
[/td][td]ZAD[/td][td]
VERO​
[/td][/tr]
[/table]
[Table="width:, class:grid"][tr][td]Sheet: 3[/td][/tr][/table]
 
[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][/tr]
[tr][td]
1​
[/td][td]Item[/td][td]Dup?[/td][/tr]


[tr][td]
2​
[/td][td]FAD[/td][td]
VERO​
[/td][/tr]


[tr][td]
3​
[/td][td]KAD[/td][td]
FALSO​
[/td][/tr]


[tr][td]
4​
[/td][td]FAD[/td][td]
VERO​
[/td][/tr]


[tr][td]
5​
[/td][td]ZAD[/td][td]
VERO​
[/td][/tr]


[tr][td]
6​
[/td][td]LAD[/td][td]
VERO​
[/td][/tr]


[tr][td]
7​
[/td][td]LAD[/td][td]
VERO​
[/td][/tr]


[tr][td]
8​
[/td][td]NAD[/td][td]
FALSO​
[/td][/tr]


[tr][td]
9​
[/td][td]JAD[/td][td]
FALSO​
[/td][/tr]


[tr][td]
10​
[/td][td]XAD[/td][td]
FALSO​
[/td][/tr]


[tr][td]
11​
[/td][td]ZAD[/td][td]
VERO​
[/td][/tr]
[/table]
 

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top