Question

Please help in conditional formatting formula when to find the highest score of a single student in maths and science?

Answer 1

Answer:  Please help in conditional formatting formula when to find the highest score of a single student in maths and science?

i dont no

Explanation:

Answer 2

PHOTOSHOP SOFTWARE TIPS AFTER EFFECTS SONY VEGAS AUDACITY ADOBE ILLUSTRATOR ADOBE FLASH FL STUDIO FINAL CUT GARAGEBAND AUTODESK 3DS MAX MAYA IMOVIE CINEMA 4D ITUNES ADOBE PREMIERE ADOBE DREAMWEAVER PRO TOOLS REASON ADOBE ACROBAT MOVIE MAKER ADOBE INDESIGN LOGIC STUDIO ADOBE FIREWORKS IWORK ZBRUSH CAMTASIA STUDIO IPHOTO BRYCE 3D AVID EDITING FILEMAKER PRO ADOBE BRIDGE LIGHTWAVE 3D EMBIRD QUARK SOFTWARE WONDERHOWTO

HOW TO

Use conditional formatting for a student grading report in Microsoft Excel

BY NITIN KOTHARI 09/07/2010 1:36 AM 09/13/2010 2:31 AM

If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.

Column A and Column B are the inputs by the user and Column C is the grade of the students that is dependent on the following four criteria:

1. If obtained marks are more than or equal to 80, and less than 90, then grade would be "A"

2. "..." 70, and less than 80, then grade would be "B"

3. "..." 60, and less than 70, then grade would be "C"

4. If obtained marks are less than 60, then grade would be "Failed"

For above purpose, put this "IF" function in C4 column. The function is:

=IF(B4>=80,"A",IF(B4>=70,"B",IF(B4>=60,"C","Failed")))

Then copy this function to all the required cells. Then, time for some conditional formatting on column C for the following criteria:

A. If marks are greater than or equal to 80, and less than 90, then background color of the cell should be green

B. "..." 70, and less than 80, then background color of the cell should be purple

C. "..." 60, and less than 70, then background color of the cell should be gray

To achieve this follow the step-by-step process:

1: Select the cells of C column (Grade) where conditional formatting is to be applied.

2: Click Format Menu.

3: Choose Conditional Formatting.. From the menu.

4: Conditional formatting dialogue box will be appeared on the screen. Under condition 1, choose Formula Is from the drop down menu and then type this formula in the text box:

=AND(IF(B4>=80,B4<90))