PC Review


Reply
Thread Tools Rate Thread

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:43 PM.