I want to attach a macro to text box so that it does conditional formatting after all cells in a range have been completed, rather than the "live" version through the conditional formatting wizard.

In column B1:B10 I have a list of answers, in column C1:C10 I have used a formula that produces a "1" if the answer is correct and a "0" if incorrect.

What I would like the macro to do is format the background of the correct answers to green and delete the incorrect answers.

Sounds easy but I only know how to do a conditional formatting macro for a particular cell, not based on the result of another.

Any help would be appreciated.

Cheers, Teeb.