Shading Cells

[young engineer]

Hi All
I would like to to add a colour coding feature to certain cells, whereby if the value in it is less than 95%, the cell would become shaded.
How do i do this.

 

[c_m]

Try conditional formatting.
Format>>Conditional formatting>>Select "Cell Value Is" from first drop down list>>Select "less than" from second drop down list>>type 0.95 in text field>>select you desired format