Conditional Formatting

 Conditional Formatting is to apply unique cell formatting  based on a certain condition.

Highlight Rules
 • Top/Bottom Rules 
 • Data Bars 
 • Color Scales 
 • Icon Sets 
 • Add your new rule! 

Adding New Rule   - add a formula that contains a condition and add new formatting. Ex: =A1=“PASSED”  this formula will result to TRUE or FALSE If that formula is true, the format to be set will be applied to the cell 

On a personal note, conditional formatting can help us in making our works easier since it is the one who arranges the identification based on the formula that we gave to it. 

This is an example of a grading sheet using CONDITIONAL FORMATTING and NESTED IF