Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fstudley
 
Posts: n/a
Default EXCEL Workbook tab format options: change color or font

Excel workbook worksheet tabs should have 'change color/font' options for
priority visibility. My company uses Excel worksheets as testing templates
in our bio-tech QC laboratory. Some workbooks have multiple worksheet
templates in them and although they are all named, it would be more efficient
to be able to prioritize a worksheet visually by changing that specific
worksheet's tab color to YELLOW or the font to BOLD RED. All our worksheets
tend to look similar and if a technician isn't paying close attention to the
tab name, they sometimes use the wrong one and have to duplicate their work
later.
  #2   Report Post  
Arawn
 
Posts: n/a
Default

Right-Click on the Sheet tab, there is an option to change Tab Color.

  #3   Report Post  
fstudley
 
Posts: n/a
Default

That doesn't seem to be an option in my Excel 2000 version. Is this
available only in newer versions? Or can I somehow activate that option in
tools or preferences?

"Arawn" wrote:

Right-Click on the Sheet tab, there is an option to change Tab Color.


  #4   Report Post  
Arawn
 
Posts: n/a
Default

Excel XP and 2003 have that option. Your SOL for earlier versions if
you want color on your sheet tabs. If you want those features, you're
going to have to update.

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
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
How Do I change the background color of a cell in microsoft excel. amac Excel Discussion (Misc queries) 1 February 25th 05 07:49 PM
How to change the excel format from language to language? zee Excel Discussion (Misc queries) 2 January 30th 05 06:51 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM


All times are GMT +1. The time now is 06:39 PM.

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

About Us

"It's about Microsoft Excel"