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.
You were too slow, he's forgotten.
( Unless he's confusing the B-29 Superfortress, as in Enola Gay, with B-52 Stratofortress )
....................
B-side -- the Seaside