I remember seeing this question posted before, but couldn't
find it now.
I have a workbook with a number of groups of worksheets. I
would like to color code the tab name. How do I do it?

Thanks,
pac

Hi
if you have Excel 2002+ just right-click on the tab and choose 'change
color'.If you have an older Excel version: not possible

--
Regards
Frank Kabel
Frankfurt, Germany

comp wrote:
> I remember seeing this question posted before, but couldn't
> find it now.
> I have a workbook with a number of groups of worksheets. I
> would like to color code the tab name. How do I do it?
>
> Thanks,
> pac

Right click on the worksheet tab and and click color tab, only works with
excel 2002 and above


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"comp" <(E-Mail Removed)> wrote in message
news:LWexd.293$Y57.187@trnddc08...
> I remember seeing this question posted before, but couldn't
> find it now.
> I have a workbook with a number of groups of worksheets. I
> would like to color code the tab name. How do I do it?
>
> Thanks,
> pac
>
>

If you have Excel 2002, or later version, right-click on the sheet tab
Choose Tab Color, and select a colour.

There's a picture in the Excel FAQ:

http://www.contextures.com/xlfaqApp.html#TabColour

comp wrote:
> I remember seeing this question posted before, but couldn't
> find it now.
> I have a workbook with a number of groups of worksheets. I
> would like to color code the tab name. How do I do it?
>
> Thanks,
> pac
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Wow!
Thanks for quick responses. I have Excel2000 at home, but
2003 at work. Looks like I an in for an upgrade.
Thanks much,
pac

comp wrote:
> I remember seeing this question posted before, but
> couldn't
> find it now.
> I have a workbook with a number of groups of worksheets.
> I
> would like to color code the tab name. How do I do it?
>
> Thanks,
> pac

Redmond's dream type customer ... upgrade for the colored tabs !?!?<vbg>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"comp" <(E-Mail Removed)> wrote in message
news:zbfxd.296$L7.273@trnddc05...
> Wow!
> Thanks for quick responses. I have Excel2000 at home, but
> 2003 at work. Looks like I an in for an upgrade.
> Thanks much,
> pac
>
> comp wrote:
> > I remember seeing this question posted before, but
> > couldn't
> > find it now.
> > I have a workbook with a number of groups of worksheets.
> > I
> > would like to color code the tab name. How do I do it?
> >
> > Thanks,
> > pac
>
>

Well,
It's all in teh presentation :-).


Ragdyer wrote:
> Redmond's dream type customer ... upgrade for the colored
> tabs
> !?!?<vbg>
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so
> all may
> benefit !
> ---------------------------------------------------------------------------
> "comp" <(E-Mail Removed)> wrote in message
> news:zbfxd.296$L7.273@trnddc05...
>> Wow!
>> Thanks for quick responses. I have Excel2000 at home,
>> but
>> 2003 at work. Looks like I an in for an upgrade.
>> Thanks much,
>> pac
>>
>> comp wrote:
>>> I remember seeing this question posted before, but
>>> couldn't
>>> find it now.
>>> I have a workbook with a number of groups of worksheets.
>>> I
>>> would like to color code the tab name. How do I do it?
>>>
>>> Thanks,
>>> pac