Saying "did not work" isn't very constructive. You probably got something messed up in your Conditional Formatting.
Attached you will find my testing. Have a try changing grades in column C.
"A" already is done, now enter "B" in cell C2 and pull down and see the difference and finally do the same with "C".
|