Conditional Formatting Data

 

-Follow along using the Excel Spreadsheet by Clicking Here.

 

Final Notes:

This tutorial has been conducted using fake student information. This tutorial was conducted on a PC, meaning if you're using a Mac, the layout may look differently.  For example, there may be different steps to plug in a formula into conditional formatting.  If this is the case, simply watch an additional Youtube tutorial on how to navigate through conditional formatting using your specific version of Microsoft Excel.