Assignment 4 Result Table

Conditional Formatting (Result Table)

Formula uses in Result, Grade, Rank

Rank :- Rank function use to return the rank of a number in a list of number. The rank of a number is its size relative to other values in a list.

Sum :- Sum function is use to add all the number in the range of cell and return the result of the addition.

IF :- The if function can perform a logical test and return one value for a "TRUE" result and another one for a "FALSE" result.

Function use for Result

=$C$17=$J4 :- This is use to find result is true or false in condition formatting . if one criteria cell ($C$17) is equal to result column cells then cell row highlight otherwise check to other cell.

Note :- In the result cell if i will write pass then all student must be highlight which is pass in that table and if i will type fail then all fail student gets highlighted.

Function use for Grade

=$F$17=$k4 :- This is use to find grade in grade column. for example if I'll write "A" in criteria cell($F$17) then this formula find Grade "A" in a range.

Note:- There is grade cell also I'll write any grade which be in the grade column when I'll write any grade like "A" then all students gets highlighted which have grade "A" and same for all.

Function use for Rank

=Rank($I4,$I$4:$I$13,0)=$I$17

Rank:- Rank function return a rank number in a row.

$I$4:$I$13 - cell range

$I$17 - Rank cell (criteria cell)

Note :- There is rank cell also in which I'll write the rank number of student from 1 to 10 that particular student get highlighted from that table.

Note :-

All function are apply to conditional formatting, To apply this function follow these steps.

• Go to conditional formatting tool.

• Select the "New Rule..."

• Select the "Use a formula to determine which cell to format".

• Click on "Edit the rule description" then type the function.

• After that go to the format and choose the option which you want it all depend on you and click on "Ok" and again click on "Ok".

• Again open conditional formatting tool and choose manage rules then you can edit your function.

• Open condition Formatting tool and click on "Applies to " and give the range of whole table.