Tracking textual Data changes beween 2 columns & highlight diff nu
in [General]
|
Prev: How do I calculate interest?
Next: Tracking textual Data changes beween 2 columns & highlight diff nu
From: Rameses on 3 Mar 2010 19:45 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 |