We can assign a total of three conditions for conditional formatting. Now try with different points, when you need points, according to notes of the bottom of the cell does not change.
Column A: The name of the student
Column B: brands
Column C: Grade
Column A and Column B is input by the user and column C is the degree of students who depend on four criteria:
1. If the points were obtained greater than or equal to 80 and less than 90 degrees will be "A"
2. If the points were obtained greater than or equal to 70 and less than 80 degrees would be "B"
3. If the points were obtained greater than or equal to 60 and less than 70 degrees will be "C"
4. If the acquisition of points below 60 degrees would be "failed"
For the above purposes for the "IF" according to the C4 column
The function is = IF (B4> = 80, "A", IF (B4> = 70, "B", IF (B4> = 60, "C", "Failed")))
and then a copy of this to all the cells needed.
Now I need a conditional formatting in column C for the following criteria:
a. If the points are greater than or equal to 80 and less than 90, then the cell background must be green
b. If points are greater than or equal to 70 and less than 80 then the cell background must be purple
C. If the points are greater than or equal to 60 and less than 70, then the cell background must be gray
To do this, follow the process step by step:
Step 1: Select the cells in column C (degrees), where conditional formatting will be applied.
Step 2: Click on the Format menu.
Step 3: Conditional Formatting, then select.. In the menu.
Step 4: dialog Conditional formatting appears on the screen. Under Condition 1 Select the formula down menu and type these formulas in the text box.
= AND (IF (B4> = 80, B4
ไม่มีความคิดเห็น:
แสดงความคิดเห็น