Need conditional statement to paint a cell
 

You can use conditiona formatting. Select the area where the grades are
entered and then select Foramt - Conditional Formatting. Change the cirteria
to less than and then enter the value...
--
HTH...

Jim Thomlinson


"M.L." wrote:

I'd like to embellish my gradebook by automatically painting cells a
specific color when the grade entered is less than 70. Any help will
be greatly appreciated. Thanks.