Basic formulae for MS Excel stockmarket / forex spreadsheet

I have a MS Excel 2010 spreadsheet containing OHLC price data, and ATR / Keltner Channel values for each row. I need further calculations applied to specific rows as outlined in the Detailed Requirements. ## Deliverables RULESET ONE a1) Find the first row where C is > I (for example row 27) a2) Count forward the number of rows specified in S10 (for example "2") a3) Does the value of D in each of the count-forward rows (ie D28 and D29), stay above the value of the first row's D value (ie D27). If so mark row 27 as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat b1) Find the first row where D is < J b2) Count forward the number of rows specified in S10 b3) Does the value of C in each of the count-forward rows, stay below the value of the first row's C value. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat RULESET TWO c1) Find the first row where C is > I c2) Count forward the number of rows specified in S10 c3) Does the value of D in each of the count-forward rows, stay above the value of K on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat d1) Find the first row where D is < J d2) Count forward the number of rows specified in S10 d3) Does the value of C in each of the count-forward rows, stay below the value of K on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat RULESET THREE e1) Find the first row where C is > I e2) Count forward the number of rows specified in S10 e3) Does the value of D in each of the count-forward rows, stay above the value of J on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where C is > I and repeat f1) Find the first row where D is < J f2) Count forward the number of rows specified in S10 f3) Does the value of C in each of the count-forward rows, stay below the value of I on each count-forward row. If so mark as 'Won', otherwise mark as 'Lost'. Find next row where D is < J and repeat Calculate number of wins as a percentage of total number of trades (ie if we had 60 wins and 40 losses then the percentage of wins would be 60%) for each ruleset, so that we have separate percentage wins figure for Ruleset One, Ruleset Two and Ruleset Three.