This is a really well presented video that shows you some really cool suggestions for using Excel 2007 and Excel 2010 conditional formatting.
In the first example it shows you how to insert an IF and OR statement to control the contents of the cell and then applies conditional formatting to the cell to create the icons.
What is great about this video is that it does not stop there. In the second group it shows you how to apply data validation to cells to give a drop down list of values the user is able to select (always cool when you do this)
The final example does not add any new techniques but shows you how to make it even simpler.
If you have found this useful please let us know via the comments box or vote for this video using the social buttons on the right hand side.