Need help with following Employee Leave Accrued Schedule:
Max days allowed is 30 days in a year, so the moment total (cell ref:O12) days taken reaches 30 days, days taken row should get freeze or it should not allow to enter any thing in Days taken row(cell ref- C12:N12)
Thanks!


Employee Name:

Year: 2013

Leave Days:15 Max Days Allowed:30

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total
Working Days 23 20 21 22 23 20 23 22 21 23 218
Accrued 1.58 1.38 1.44 1.51 1.58 1.38 1.58 1.51 1.44 1.58 15
Days Taken - - - - - - - - - - -
Balance 1.58 2.96 4.40 5.92 7.50 8.88 10.46 11.97 13.42 15 15