change column fill color

vincentwady@gmail.com

Guest

Posts: n/a

6th Nov 2007

Dear all,

I have a simple issue. There are 200 tabs in one excel file. I want to
change the current tab column fill color(gray-25%) to new column fill
color(light yellow). Because the gray column is no constent rule,
separate in all the cell, I am thinking whether there is a way to
write a macro to just change all of the column fill color?

Thanks

Vincent

« Disable inserting or deleting row in selection of rows | Year date format »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 - change fill color from one color to another	okiedokiedoo	Microsoft Excel Misc	1	30th Dec 2007 10:25 PM
How to fill a column with color in statement	=?Utf-8?B?YW5hbWFyaWUzMA==?=	Microsoft Excel Programming	3	2nd Apr 2007 03:52 PM
change fill color of a range of cells based on color of a cell?	=?Utf-8?B?RGFyTWVsTmVs?=	Microsoft Excel Programming	0	2nd Mar 2006 06:35 PM
Fill column with color	tpk1031	Microsoft Excel Programming	1	20th Sep 2004 08:36 AM
Find first and last cells in column that have a certain fill color	Ashleigh K.	Microsoft Excel Programming	1	11th Dec 2003 03:54 PM