Hi

i am making a template for school reports and one column has the grades which are from 1-5.

if i write 5 or 4 i need the cell to automatically change to a light shade of green

if i write 1 or 2 i need the column to automatically change to a light shade of red

how can i do this. (each child has 30 modules so this will really help out in a big way)