Same workbook (attached)
"Timesheet" Column N - Total Hours is populated when I run the code.
The cells in Column N have conditional formatting in them that will turn the cell in Total Hours Red if the time entered by a timekeeper in
H2, J2, L2 are Greater than the populated amount in N2.
What I need to do is insert a yes/no check box in A2:A300 with an IF Statement that says
IF checked yes, then Sum H2,J2,L2 and Total them in N2 but also turn the cell Green.
IF checked No then keep the populated total the same and keep the cell Red.
I hope I explained this properly. See attached.
This is very important so any help is as always appreciated.
Thanks,