Conditional formatting is a very useful part of all spreadsheet programs if used properly. We will begin with a common use by teachers which is to grade. After this opening lesson we will use conditional formatting to create more complex items such as color coded lists of point leaders. Giving gold, silver, and bronze backgrounds based on which place a person is in.
This video gives a short run down of the basics of conditional formatting.