Table formatting VBA CODE

[shoun2502]

I am looking for a vba code to have my customized table formatting as I need to execute the same for numerous table and is cumbersome without the code.


The details are mentioned below for the reference.


1. Text : Calibri 10
2. First Column, Row and Last Column Fill colour coding
RGB, Red:49, Green:133, Blue: 156


3 Rest all cells to be color filled
RGB , Red:219, Green:238, Blue:244


4 Text colour to be white & "Bold" for First Column and Row , Last Column


5 Text colour to be black for Remaining Cells




It would be indeed helpful if the forum could address the issue and help me writing the code and subsequently shall surely help me in saving a lot of time.

 

[My Aswer Is This]

Similarly, If I have Some data having borders not table Is it possible to execute the code in similar formatting.
With First,Last row and First Column.

Please do help me with that.

I'm not sure what your now asking for.

I do not like it when posters keep adding more and more to their original post.
And I do not understand this request.
And now I see you have posted this same question on another forum.

 

[shoun2502]

Thanks for the reply. I do acknowledge your point of view.
Actually I was trying for the last row as well, so eventually got stuck with that.


Thanks anyways.

 

[My Aswer Is This]

I never saw anything in your original post about Last row. But maybe I need to go read that again.

Thanks for the reply. I do acknowledge your point of view.
Actually I was trying for the last row as well, so eventually got stuck with that.


Thanks anyways.

 

[My Aswer Is This]

I like the challenges here. But...

Hope this helps you.

 

[My Aswer Is This]

Just for your information.
You can do this:

Create a table.
Click some place on the table

On the ribbon choose Table Tools Design

On the far right you should see Up Down Icons click down icon
You should see New Table style

Click on that and you can create a whole new table style
And then use that table Style any time you want.
There are numerous options here.