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.

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

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.

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.