Conditional Format vs VBA

[paleaux]

Ok I have a workbook that is currently using vba to copy Total Hours from the "Gate Log" worksheet to "Timesheet" worksheet.

I would like to create a yes/no check box in A2:A300 for each row..
What I need to do is Sum the hours entered into I2,K2,M2 into O2.
and format O2 to turn Red if O2 is >E2, but If check box is checked in A2
then turn Green.
If check box is not checked in A2, then O2=VALUE IN E2.

I am going crazy with this...can someone please give me a hand....

Thanks,