EXCEL Workbook tab format options: change color or font

G

Guest

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.
 
G

Guest

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?
 
A

Arawn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top