On Jun 8, 12:34*pm, DKS wrote:
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- Hide quoted text -

- Show quoted text -

The sheet has one row per student and records performance in the
different terms in different columns.