VBA conditional formatting not working

Good afternoon,
I have an excel programming book that has an example of the conditional formula I would like to use. I have modified it to fit my spreadsheet but it still doesn't work.
Basically what should happen is: If they put in a forumla 7/8 = 88% then the cell should be red, if 8/8=100% then green else no color. I tried using the conditional formatting in the too bar but it turns all cells red.

Did I put the code in the wrong spot? or am I missing something?

I have attached the spreadsheet so you can see what I am doing.

Thank you!
Larry