VBA code to change font color in range of cells when certain text is entered?

Hello, forgive me in advance as I am very inexperienced with VBA and conditional formatting, especially in Excel 10 (most of the help I've found online is 03 or 07). Here's what I'm trying to accomplish:

I have a worksheet that is used to calculate GPA based on letter grades and credits. In the column where the letter grade is entered, I want the text to turn red if the grade is a C- or lower (C-, D+, D, D-, F). If the grade is C or higher, I want the text to stay black. If C- or lower is entered in the cell and the text turns red, I want it to turn black if a C or better is later entered in that cell. The range of cells on the worksheet is E10:E30. Also, the sheet is protected, but these specific cells are not. Any suggestions? Thanks ins advance for your help!

To the Sheet module in question.

Please Login or Register  to view this content.

Thanks for the help. I entered this code but it doesn't seem to be doing anything. Any ideas?

It only runs when you change any cell(s) in E10:E30

Hmm, still not doing anything for me. I opened what you just attached, enabled content, typed "c-" into e10, it was black. Changed it to "d", it was still black.

You said

C-, D+, D, D-, F

Not

c-, d+, d, d-, f

I didn't realize it was case sensitive. One last question, then (hopefully). How do I go about altering this line of code to include both cases of each letter?

Please Login or Register  to view this content.

I tried what I thought would be right, but it wasn't.

Thanks for your help and patience.

Add one line

Please Login or Register  to view this content.

Ahh, that's so easy, thank you. Sorry, ONE more. How do I make this work with a protected sheet? Otherwise, this works perfectly!

I get "Compile error: Wrong number of arguments or invalid property assignment" and the following line is highlighted yellow in the VBA code:

Please Login or Register  to view this content.

OOps,

No comma...

Please Login or Register  to view this content.

Thank you SO very much! Happy holidays to you.

You are welcome and the same to you.

hi BrianG, there is a built-in feature to do that - Conditional formatting, why bother with codes