The worsheet that I was doing yesterday and how to get the same result

The media is the excel that operates for you, the result approved or disapproved or exam is the excel that fills it for you, the number of the students that is approved, disapproved and for exams is the excel that finds for you, and the stile of if disapproved is in red is the excel that gives,

so how to do a worksheet that gives all those results...

First you make the formula for the media...

Now you will make the conditional formula, in my that is in Portuguese is 'se' in English 'if', I used the formula helper, and fill the forms but is the same that the formula that you see, you write that formula and you would have 3 levels of results, is only on formula for approved disapproved and for exams, and a extra tip instead of put the grade have to be higher than 60 you put higher than 59, the apostille that I study said higher than 60 so higher than 60 is 61 and was approved only the student that got 61, maybe is better for the course do this way because some students would instead study use the worksheet with even need understand.

And for this I formula that every cell that has the result that I describe and was a name approved...

...exam...

...disapproved...

And how make the excel write in red and rose box when the student is disapproved, go to the stile box in my excel is in the first tab, all that I use in this worksheet was in the first tab.

The last step of the stile of the disapproved is in red.

Rute Bezerra de Menezes Gondim