Tracking textual Data changes beween 2 columns & highlight diff nu

[Rameses]

Hi there

OK I am tracking Students BTEC grades and am going round on circles

The Data Range is the same in both columns A&B. This is arrayed order below

Dist*
Dist
Merit
Pass
Fail

Column A is students Targeted grade and column B is Students current Progress
I want to compare the 2 and in column C want to add in a value to express
the difference between their targeted and current grades (therefore showing
how much the students are passing or failing their BTEC course)

Some examples are as follows

If A1 = Dist
and B1 = Merit
Then C1 should show -1

A1=Merit
B2 = Fail
C1 should show -2

A1 = Pass
B1 = Dist
C1 should show 2

C range would therefore be from 4 to -4

After I have done this I then want to add conditional formatting to column c
but I can do this

Please, please help

many thanks

Rameses

 

[:)]

Is it possible for you to show Dist* as High Dist instead. If so, in column
D, add in the following:

D1 - High Dist
D2 - Dist
D3 - Merit
D4 - Pass
D5 - Fail

In column C paste this =MATCH(A1,$D$1:$D$5,0)-MATCH(B1,$D$1:$D$5,0)
Drag this down. See if this works for you.