Can the sheet tabs be color coded?
 

Does anyone know a way that the worksheet tabs on a spreadsheet can be color
coded?

Can the sheet tabs be color coded?
 

Right click on the tab name and select 'Tab Colour'

HTH

Giz

"Lynn" wrote:

Does anyone know a way that the worksheet tabs on a spreadsheet can be color
coded?

Can the sheet tabs be color coded?
 

When I right click on the tab, I get the following:

Insert
Delete
Rename
Move or Copy
Select all Sheets
View Code

I have Excel 2000 - I don't know if that is the problem or not.

"Gizmo63" wrote:

Right click on the tab name and select 'Tab Colour'

HTH

Giz

"Lynn" wrote:

Does anyone know a way that the worksheet tabs on a spreadsheet can be color
coded?

Can the sheet tabs be color coded?
 

Colored tabs were introduced in Excel 2002. They are not
supported in earlier versions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lynn" wrote in message
...
When I right click on the tab, I get the following:

Insert
Delete
Rename
Move or Copy
Select all Sheets
View Code

I have Excel 2000 - I don't know if that is the problem or not.

"Gizmo63" wrote:

Right click on the tab name and select 'Tab Colour'

HTH

Giz

"Lynn" wrote:

Does anyone know a way that the worksheet tabs on a
spreadsheet can be color
coded?

Can the sheet tabs be color coded?
 

That's our difference.

I don't think it can be done in 2000. Can someone else confirm this?

"Lynn" wrote:

When I right click on the tab, I get the following:

Insert
Delete
Rename
Move or Copy
Select all Sheets
View Code

I have Excel 2000 - I don't know if that is the problem or not.

"Gizmo63" wrote:

Right click on the tab name and select 'Tab Colour'

HTH

Giz

"Lynn" wrote:

Does anyone know a way that the worksheet tabs on a spreadsheet can be color
coded?