I know this subject has been on here before, being a complete novice most of the solutions are way above my head. I need a nice and simple solution if there is such a thing. I have a wookbook with conditional formatting where workmates fill in required data, if some of these cells are missed for any reason they show the colour. I wish to remove all the colour before printing, then resore it again once printing is finished.

Hope you can help, remeber (KISS) Keep It Simple Stupid, so that I may follow.