Searches through a range and changes back color according to values

[Dalton626]

I am doing a spread sheet for participation in a class. What I want is for whenever a student is absent, i.e. has a 0 in their point box for the day, that cell turns red. I have tried to make the .find method work but it has been uncooperative and so far and I can't seem to get it to even run. This is what I have so far:

[alansidman]

Try this:

Please Login or Register  to view this content.

[Dalton626]

Thanks a lot. The code runs great!