[Abandoned] Controlling conditional formatting using checkboxes

I have decided to abandon the task of controlling the conditional formatting using checkboxes as it seems impossible to do so in excel 2007. There may be a way but as time is running out for the completion of the system, I fear I will not have time to test it (although there is a testing phase later in the year) or correct any glitches it may pose.
It's a shame really. Adding a function like that would of just increased it's uniqueness to other peoples system. I will not stop searching yet as there may be a way to do it but as outlined before, it may be too late to implement it.