As I am not on my work laptop I can't give a blow by blow guide as I use Open Office on this system, however, there is always GOOGLE;
http://www.contextures.com/xlcondformat03.html
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel
etc
And that is part of the problem - who makes the assessment ?
At my wife's school the OFSTED inspectors have identified a couple of areas 'of concern', but the specialist team brought in to help say that there is nothing wrong.