Can you give more information on the layout of your sheet? Because the
formula could be different depending on the layout.

Let me explain:

Is your sheet with one row per student and different columns giving
different periods?

Or is your sheet with one row per student per period? Meaning you could
have several rows with the same student but for different periods? If this
is the case then are your data sorted as per period or not?



"staffrmj" wrote:

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