I've read through a bunch of this forum's postings and googled, but cannot find an answer, so some help would be greatly appreciated.
Here's the situation: I'm a teacher and I need to determine whether my students meet the requirements to go on an internship abroad. Some requirements are simple, such as having completed all the course work from the first year. I can do this quite easily and it works. However, should a student wish to do the internship in a language other than English, he needs to meet more detailed requirements:
If the student is currently at level 3 in this language, he needs to complete this level with at least a 7.
If the student is currently at level 5 in this language, he needs to just pass this level, which is a 5.5.
I have two columns, one for level and one for score. What I'd like to do is change the color of the score cell green if the student meets the requirements and red if he doesn't. I've tried this in a number of ways, with regular conditional formatting, with some IF formulas, but I can't get it to work. It's probably fairly easy for the more experienced Excel users out there, but it totally baffles me.
Thanks a million!
Bookmarks