Excel 2013: How to use Conditional Formatting

Two great real-life examples (a training course booking system and a project RAG status report) of how to use Conditional Formatting to automatically change the background colour of cells based on the text value (i.e. words) in the cells