Discussion Locked

Change sheet tab color in Excel 2000

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to find out how to change the background color on the sheet tabs in Excel 2000.

6 replies

by justmeangie

I have two things on color with excel not sure if this will help but.... was worth a try both of these i recieved in tech mails :)

Using Excel's color codes
When you edit a formula, Excel displays the ranges the formula refers to by placing colored borders around the ranges. You can easily change these references by dragging the ranges with the mouse. This method is very convenient and often quicker than manually editing range references.

Let's look at how it works. First we'll set up asimple worksheet with a formula. Follow these steps:
1. Enter numbers in A1:A5.
2. Enter different numbers in C1:C7.
3. Select cell A6 and double-click the AutoSum button on the Standard toolbar.
4. Select cell A6 and press [F2] to go into Edit mode.
The range A1:A5 is bordered, and the reference A1:A5 in the formula is the same color as the border. If a formula refers to several ranges, Excel uses different colors for each reference.

To resize the reference, point the cursor at the bottom-right corner of the range and drag the handle until it surrounds the desired area.

To move the referenced range, point anywhere on its colored border and drag the frame to a new location. To try out these methods, change the formula so it totals the values in C1:C7 instead.
Color-coordinate your worksheetsDo you remember the blue-and-white z-fold paper used for computer printouts? The design of the reports may not have been much fun, but at least it was easy to follow the lines?especially because of the colored paper. But you can also use this in Excel to help distinguish between entries. Let's use conditional formatting to make the rows of a list alternate between yellow and green. Follow these steps: 1. Select rows 1:20. 2.Choose Format | Conditional Formatting. 3. For Condition 1, choose Formula Is from the drop-down list and enter the following formula: =MOD(ROW()-1,6)<=24. Click Format. On the Bor

This discussion is closed to new replies.