If formula based on cell colour

OK so i think my last issue is in the macroing.

what i want is with the check boxes i want it to change things when the check box is checked

first off look at the attached example please

Macro Help.xlsx

When i enter a number in the po# column i want it to create a check box in the printed column and when the printed column is checked i want it to first check the color of the method cell and if yellow create the formated check box in the formatted column if any other color leave formatted column blank. If a formatted check box was created when it is checked have it create the emailed check box other wise if no formatted check box is created then create a check box in the emailed column and when the emailed box is checked i want it to change the cell color of the confirmed box to red until the check box for confirmed is checked then turn it to green.

please help me if this is something that can be done.