Excel sheet color problem, why does the whole table of Excel always change color?

Maybe he's formatted it for you.

Why don't you restore the excel defaults?

How to restore default settings for word and excel solves the problems encountered.

In the process of using word and excel, you may encounter various problems, such as not being able to add special symbols, not being able to find the toolbar you want, the interface is confusing, and you want to restore the default or original settings, but you can't find the relevant buttons on word and excel, so what should you do?

Word Recovery Default Settings:

Method 1: You can open the program to run——— if it's a word problem, enter it" -a

Everything okMethod 2: Close the Word program, and then go to the directory where the default template of the Word program is located, Microsoft Templates, which will be named Normaldot file renamed to a different file name, and then start Word, and all its settings and interface have been restored to the state just after installation.

C: Documents and Settings login username Application Data Microsoft Templates, where the Application Data folder is an implicit folder).

Excel restores default settings:

Program Run ——— input"-s, you can start the safe mode file setting.

If you delete this file and re-execute Excel, the preset menu settings of Excel will be restored.

Excel XP Location: C: Documents and Settings Login username Application Data for Microsoft Excel

Please refer to other versions.

excel 5:

excel 95: .xlb

excel 97:

excel 2000:

excel xp:

It is recommended to use search file *xlb(normal.dot).

The easiest way to do this: reload Excel

1. I display "blue" when I enter the sample in column D of the excel sheet, and "red" when I enter the order, I want to cancel this function.

2. First of all, select column D.

3. Click "Conditional Formatting" in the start menu and "Manage Rules" in the drop-down menu

4. At this point, we can see that the reason why the font changes color is because of the rules set in the conditional formatting.

5. Put a checkmark in the box to the right of the rule.

6. Then click "Delete Rule" at the top

7. Click the "OK" button at the bottom of the dialog box after deleting.

8. At this point, we see that the font in column d has no color.

The problem is too vague, excel colors are varied, it can be the entire **background color, it can also be a single cell background color, it can also be a conditional formatting color, here is the whole **background color as an example to answer, the first step: select the whole**, and then select the color, <>

1. First select the cell range and click "New Rule" in "Conditional Formatting".

<>3. Then click the "Format" option, click the color of the fill as the desired color, and click OK.

4. Then the cell will turn red after entering a specific text in the cell, at this time, Turner can select the whole row of cells and set the same red.

The sensation can be caused by several reasons:

Excel software settings issues: You may have changed the default settings in your excel software, causing those changes to be applied every time you open excel**. You can find these settings in the excel option and change them with potato cracks.

File Format Issues: If your Excel** is saved in an older version of Excel format, such as XLS, instead of the newer XLSX format, then it may have formatting issues. You can save ** as a new format and reopen it to fix this issue.

Infection with Occlusion: Some viruses may change the format and content in your Excel**. Make sure your computer has the latest antivirus software and run a comprehensive virus scan to resolve the issue.

Operational error: In the end, it may be that you accidentally changed the format and content while excelling, and forgot to save or undo the changes. Make sure you double-check your changes and save them properly.

1. I see "blue" when I enter the sample in column D of the excel sheet, and "red" when I enter the order, I want to cancel.

within this feature.

2. First of all, select column D.

3. Click "Conditional Formatting" in the start menu and "Manage Rules" in the drop-down menu

4. At this time, we can see that the reason why the font changes color is because rule 5 is set in conditional formatting, and the box on the right side of the rule is checked.

6. Then click "Delete Rule" at the top

7. Click the "OK" button at the bottom of the dialog box after deleting.

8. At this point, we see that the font in column d has no color.

This is due to **bai

The reason for setting up conditional formatting.

zhi, clear the format, step dao

The sudden is as follows: 1. Start and return to Excel to open the answer file, as shown in the following figure:

2. Click the Start tab and click the Style button;

3. Click Conditional Formatting in the pop-up menu, and click Clear Rules in the lower menu --- clear the rules of the entire worksheet;

4. The effect is as follows:

Select the whole table, click the "Fill Color" button (for the small bucket pattern), - select "No Fill Color". And it turned white.

That's what color you filled in before you did this**.,And then after doing the next **, it's always defaulted to the following **coloring.。

Is it a color set in conditional formatting? You can change the color according to the set conditions.

Formatting--Conditional Formatting(Set conditions as you need)--Formatting-pop-up "Cell Formatting Window" can be set in it - Set cell shading in "Pattern".

<> "The results are as follows: <>

This basically meets the requirements of filtering out yellow and red. It has been confirmed that only one color can be filtered at a time by color.