I came across this problem in Excel

Select the data source first, then go to the format menu bar and select the conditional formatting item, open the option, the condition 1 pane in the pop-up dialog box remains unchanged, select greater than in the second pane, fill in 85 in the third pane, (because you are asking for a number greater than 85), there is a format at the bottom, click it, a dialog box will pop up, there is a color in the font to select red, and then click OK and then OK OK!!

1.The results of each subject will be selected first.

2.Click "Formatting" in the menu bar, and a dialog box will appear.

3.The drop-down menus in the dialog box are selected as "Cell Value", "Greater than", and "85".

4.Click the "Format" button in the dialog box, find "Color" in the font label, and select the red color.

Let the data display be different colors.

In the Student Achievement Analysis Form, if you want the total score to be greater than or equal to 500 points, the score is shown in blue, and the score less than 500 points is shown in red. The steps are as follows: firstly, select the column where the total score is located, execute "Format Conditional Formatting", in the pop-up "Conditional Formatting" dialog box, set the first box as "Cell Value" and the second box as "Greater than or equal to", then enter 500 in the third box, click the [Format] button, in the "Format Cell" dialog box, set the color of "Font" to blue, and then click the [Add] button, and set less than 500 in the same way, and set the font to red, Finally, click the [OK] button.

At this time, as long as your total score is greater than or equal to 500 points, it will be displayed as a blue number, otherwise it will be displayed in red.

Simple question

The results of each subject are selected.

Click "Formatting" in the menu bar - "Conditional Formatting".

The drop-down menus in the dialog box are selected as "Cell Value", "Greater than", and "85".

Click the "Format" button in the dialog box, find "Color" in the font label, and select the red color.

Data-Filter-Auto Filter, click the black triangle on the right side of the column header, select Custom, and set it to greater than 85 to OK. Select the data filtered in this column and set the color to red.

Then click on the black triangle and select Show all.

The results of such a subject are done.

The same is true for other subjects.

You can use the conditional formatting function to do the following (Excel 2003 as an example):

Click on the toolbar "Formatting--Conditional Formatting--and select from left to right in the dialog box: cell value, greater than or equal to, 85

Then click on the format in the lower line, and select Red in the Font dialog box - Color - OK - OK

Select "Format" in the menu - Conditional Formatting, select "Cell Value" "Greater than" "85" (respectively in the three selection boxes), and then click "Format" to select"Fonts"The "color" in is red.

Are you using Office 2007? If yes, enter 85 in the pop-up box of [Start] - [Conditional Formatting] - [Highlight Cell Rules] - Greater than] and set it to red.

Right! Conditional formatting will do the trick.

The toolbar "Formatting—Conditional Formatting—is selected from left to right in the dialog box: cell value, greater than or equal to, 85

In the font dialog box, select Red—OK.

Formatting – Conditional Formatting – select from left to right in the dialog box: cell value, greater than or equal to, 85

Then click on the format that goes down, and select Red in the Font dialog box - Color - OK - OK.

Click first"Format"

Then click"Conditional formatting"

In conditional formatting, the first box is selected"Cell value"

The second box is selected"Greater than or equal to"

Enter the third box"85"

Click again"Format", pop up"Cell formatting"box, you can choose the font or pattern to be red.

What you mentioned seems to be the same as a small question in the '06 National Title Exam.

I think the following approach will do what you want:

1) Select the cell range;

2) In the menu bar, select Format, Conditional Formatting, set conditions, and click Format to select a color to confirm.

Let's make it clearer, okay?

It seems to be possible to do it with functions.

Insert-function-logic-if

Give it a try. Give this one another try.

Right-click the cell, click "Format Cell", click "Value" in the Values tab of the pop-up dialog box, pull down the option box on the right, click the red font ", and then click the "OK" button.

In Formatting - Conditional Formatting, Settings 85 is shown in red!

Click "Formatting" in the menu bar - Conditional Formatting

If you use the formula of classification and summary to calculate the calculation, you can guess the result with the envy of the forest.

The first thing to do is to classify the given data.

Classification is conditional, and must be classified according to this type of condition.

Once the classification is complete, the calculations can be made.

Finally, the calculation is complete and it can be summarized.

Total results if.

People have already reminded you, use the function of classification and summary.

Liu Wei 1

Liu Dahai 2 Li Ming 3

Tian Liang 4 and Wang Jing 5

Zhou Xiaoqin 6, Wang Tao 7

The d function is used incorrectly and requires two arguments.

C can write the formula in this way, but the result is wrong because the values and text cannot be added.

BC Since the columns do not change and the rows change when padding down, the rows of G1 and G2 should use absolute reference identifiers.

Cell region expression.

A1: C3 (the area from the upper left corner (A1) to the lower right corner (C3))."a1:c3 b1:

e3"It is equivalent to the upper left region A1:C3 to the lower right region B1:E3, only B1:

C3 is in this region, as in the equation sum(a1:c3 b1:e3) and sum(b1:

c3) is the same. But beware with"a1:c3,b1:

e3"The difference between adding a comma indicates that the two regions before and after are added, that is, sum(a1:c3,b1:e3)=sum(a1:

c3 b1:e3)+sum(a1:e3)

Therefore, the correct answer is not a3, which is a, c, d

Click on the line number rectangle of the fourth line, select the entire line, and use the Unhide command under the Format menu. If you can't get it all out at once, run this command again. For when you hid it, you may have done it line by line.

This is a conditional judgment function, and according to the description in the figure, it is recommended to use the method of adding multiple if functions to solve the problem.

For example, from November 15 to March 15 of the following year, 100 yuan per person per month, a total of 4 months, need to be conditionally judged.

if(sumproduct(($b$2=)*1),100,0)+if(sumproduct(($b$2=)*1),100,0)+if(c4="Female",20,0)+if(d4="Sales",300,0)

It solves the heating expenses, cooling expenses, washing expenses of female employees, and travel expenses subsidies for sales staff, but I don't know how to calculate attendance, and the problem of missing meals is not considered in the formula.