How to use conditional formatting in MS Excel

The links below provide some guidance on conditional formatting.  Some are ok to use with pupils, but some are a little involved.

http://www.digitalsurvivors.com/archives/000351.php

http://j-walk.com/ss/excel/usertips/tip006.htm

http://www.contextures.com/xlCondFormat02.html

http://www.functionx.com/excel/Lesson07.htm

http://www.pcworld.com/article/id,105312-page,1/article.html