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 |
. --- 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 |
...---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 |
. --- 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..