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

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

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:

Please Login or Register  to view this content.

the formula will be applied to the entire range relatively.

It is embarrassing how simple the solution is.

Thanks so much for that!!