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)

See, for example: https://www.msofficeforums.com/word-...html#post47254

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]