Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
susielotus
 
Posts: n/a
Default Multiple fill color buttons

Can i have multiple fill color buttons in my toolbar and have them all have
their own different colors so i can change different cells to different
colors easier
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Multiple fill color buttons

I just created a temporary toolbar with a few font icons and when I used one
button, they all changed to that same color.

But there might be another option. In xl2003 (and xl2002 and maybe
earlier????), you can click on that little dropdown on the font icon.

When the 40 colors and Automatic dropdown is displayed, you'll see a little
"embossed" like area at the top of that dropdown.

You can click and drag that off the button--they you can place that "tear-off"
anywhere you want it and it'll be just another floating toolbar.

If you're using a version of excel that doesn't have this feature, maybe you
could just create a toolbar:

tools|customize|toolbars tab|new
Then on the Commands tab|format category, you can drag the font (and maybe fill)
icons to this new toolbar.

Let it float over the worksheet close to where you need it.

susielotus wrote:

Can i have multiple fill color buttons in my toolbar and have them all have
their own different colors so i can change different cells to different
colors easier


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill multiple cells depending on single cell value henrat Excel Worksheet Functions 2 November 28th 05 04:59 AM
How do I Edit Fill Down a Cell Reference to Multiple Worksheets langba Excel Worksheet Functions 1 October 8th 05 02:49 AM
Auto fill multiple sections with different names jerry Excel Discussion (Misc queries) 1 September 9th 05 04:12 AM
formula to fill text with multiple conditions jerry Excel Discussion (Misc queries) 2 September 8th 05 11:26 PM
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"