Excel how to set the background color

Single setting, you can set the cell color directly.

1. Open Excel and click on the line label.

Select all cells above, right-click - format cells.

2. Set the fill color and confirm.

You can highlight the data in a cell by using Fill Color to add or change the cell's background color or pattern. Here's how:

Select the cell you want to highlight.

Tip: To use a different background color for the entire worksheet, click the Select All button. This will hide the grid lines, but you can improve the readability of the worksheet by showing the cell borders around all the cells.

Select All" button.

Click the arrow next to the Start > Fill Color button image, or press Alt+H, H.

Start tab, the Fonts group.

Under "Theme color" or "Standard color," select the color that you want.

Font color picker.

To use a custom color, click Other Colors, and then select the desired color in the Color dialog box.

Tip: To apply a recently selected color, simply click the Fill Color button image. You can also find up to 10 recently selected custom colors under "Recent colors."

Apply a pattern or fill effect.

When you don't just need a solid fill, try applying a pattern or fill effect.

Select the cell or range of cells you want to format.

Click Start > Format Cells dialog box launcher, or press Ctrl+Shift+F.

Font group.

On the Fill tab, under Background color, select the color you want.

Cell Fill and Pattern dialog box.

To use a pattern that contains two colors, select a color in the Pattern color box, and then select a pattern in the Pattern Style box.

To use a pattern with a special effect, click Fill Effect, and then select the option you want.

Delete cell colors, patterns, or fill effects.

To remove any background color, pattern, or fill effect from a cell, just select the cell. Then click the arrow next to Start > Fill Color, and then select No Fill.

Start tab, the Fonts group.

Print cell colors, patterns, or colored fill effects.

How to set the background color to protect your eyesight in Word.

Conditional formatting does not require much of an Office version, and the following methods also apply to Office 2003.

Steps; Step 1: Select c4:h23, conditional formatting, create a new rule, use the formula to determine the cells to be formatted, step 2:

Enter the formula: =if(or($b 4="Sunday",$b4="Saturday"), 1,0), just choose the fill color.

If necessary, you can continue to communicate, and if the problem is resolved, please give a recognition!!

With the development of science and technology, computers have become an indispensable tool in people's daily life, when we use Excel to process data, how can we modify the background or font color according to the values in the cells? Next, I will tell you the origin.

The details are as follows:1The first step is to open an excel document on the computer, and we need to modify the background color of the cell with the value of 80 and 90 in the cell.

2.Step 2: After selecting the cells, click on the Conditional Formatting option under the Start menu.

3.Step 3: Click on the New Rule option in the drop-down menu.

4.Step 4: On the Create Format Rule page, select the rule type indicated by the arrow at the bottom, and set the rule description below, that is, the format that meets the requirements.

5.Fifth, click the format button, that is, the area indicated by the arrow in the field in the picture below, and set the style of the cells that meet the conditions.

6.Step 6, in the open Format Cells window, you can set the font, border, background color, etc., we set the background color to yellow, and then click the OK button below.

7.Seventh, you can return to the new format rule page and click the OK button below to modify the background color.

The above is the method to modify the background color or font color according to the values in the cell in Excel.

Click on the inverted triangle symbol next to the fill color icon above and click on your favorite color in the Theme color option. At this time, the background color is set successfully.

1. First open Excel**.

2. After entering, select the ** area that needs to be set.

3. Then click on the inverted triangle symbol next to the fill color icon above.

4. Then click on your favorite color in the Theme Color option.

5. At this time, the background color is set successfully.

1. First of all, start Excel** and open the ** that needs to change the background.

2. Click on the "Page Layout" menu and find the "Background" option.

3. In the pop-up insert** window, select "From File", find the appropriate ** on the computer, and open it.

4. After the setting is completed, you can see that the background has been added.

5. If you want to delete or change the background, select "Remove Background" under the page layout menu.

In many cases, you need to use a function to change the background color as required, and this function is more commonly used, and then please enjoy the method I collected and sorted out by using the excel function to change the background color on the Internet. Hope it helps!

How to change the background color using the excel function1. First of all, we need to start Excel2010; Then, we open the [File] - Open command in turn to open a copy of the excel data that needs to be processed.

2. Next, we select the data region; and execute the [Start] - Conditional Formatting - New Rule command.

3. At this time, we can see that the [New Format Rule] button will appear on the interface; Let's select the format of [Use formula to determine which cells to set], and then enter the formula [=mod(row(),2)=1].

4. Next, we click the [Format] button; Set the Fill Color to Red in the Format Cells that comes out, and click the OK button.

5. In this way, we can see that the [odd number of rows] have turned red; Again, we can use the same method to set the color of the even row to blue, and the input formula is =mod(row(),2)=0.

6. Finally, we can check the effect; At this point, we can see that all even-numbered rows in the selected area will turn blue, and odd-numbered rows will turn red.

Excel if formula to change the way to change color.

excel function formula to set the color.

Excel**How to set up a function to fill the color.

Excel uses formulas to set the method of displaying colors.

The method of changing the color if function in Excel2007 if the condition is met.

excel how to set the function to automatically fill in the color.

Excel2007If function is a method that changes color if it meets the conditions.

Excel uses functions to control font colors.

var _hmt = hmt ||function()

1. First open Excel**, you can see that the default background of Excel** is white.

2. Go back to the desktop and click on the control panel on the right side of the track in the start menu.

3. Open the "Appearance" menu in the Control Panel.

4. Open "Appearance" and enter the "Display" button.

5. Then click on the change color scheme.

6. Then click "Advanced" in the lower right corner of the color scheme window

7. In the "Window" project, set the color to green, and then confirm.

8. I didn't go back to excel**, and I can see that the background has been set to green.

Many netizens don't know how to set font color and background color in excel, the following are some ways to set font color and background color in excel that I have sorted out for you, I hope it will help you!

Create or open the documents you need, in any text and format.

Use the mouse to select the text you want to change the color, either a piece of text or one of the words in a piece of text, and then click "Start" "Font Color" on the toolbar

In the drop-down box of font color, we can see that there are many colors to choose from, click on the color you like the most. You can see the effect as shown below (is it much better):

Select the cells you want to add background color: a1--f3, which can be connected cells or scattered cells, and then click "Start" and "Fill Color" on the toolbar

In the drop-down box of fill color, we can see that there are many colors to choose from, click on the color you like the most. You can see the effect of the following picture (is it icing on the cake):

end

Excel doesn't let part of the text in the cell fill the back of the wheel view, but it can be solved by other methods.

Here's an example of how to do this:

1. First open Excel**, and then click Insert Shape Style.

2. The shape needed for a good shape, the color filling and contour and effect required for the shape.

3. Then set the image to appropriate transparency.

4. Then move the shape to the top of the required text, and it can be displayed as the effect of the text back Tong Fan Jing.