On Jun 8, 1:19*pm, "Bernard Liengme"
wrote:
Let's say first student is in A2 with grades in B2:K2
Select C2:K2
Use Format | Conditional Formatting
For improving grade use Formula Is: C2<B2 and make green
For lowering grade use Formula IS: C2B2 and make red

Note the logic in Excel is the opposite of what is in your head because for
Excel "A" is less than "B" in the sense that it has a lower ASCII value.

Works with single grades (will not detect A+ differs from A) - that would
need a more complex formula

best wishes
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme

"staffrmj" wrote in message

...



Can I use conditional formatting to compare text values in Excel?

I want to compare student grade performance over time and want to show
if a student's grade has increased or decreased e.g. A - B would be a
decrease, B - A would be an increase.

Thanks- Hide quoted text -

- Show quoted text -

I do need to differentiate between A and A+ - any ideas gratefully
received!!