Excel 2007 : How do I apply the same Conditional Formatting to the next row?

[furiousfox]

Hi Guys
In cell "C2" I've created a Conditional Formatting based on B2.

How do I apply the same rule to the next row?
So, in "C3" I'll have the rule based on what happen in "B3".

(I have more then 60 rows "C2:C66", and doing it manually makes me fall a sleep on my keyboard).

Any suggestions?

Thanks

[DonkeyOte]

Best to do all at once... highlight C2:C66 selecting C2 first then apply your formula just be sure to use appropriate absolute/relative references, eg:

=$C2>$B2

the formula will be applied to the entire range relatively.

[furiousfox]

It is embarrassing how simple the solution is.

Thanks so much for that!!