Need Help with MS Excel Formulas
 

asdfasdsad

conditional formatting will do color highlighting based on numbers for text.
if you cant figure out how to use it do a google search for conditional formatting.

To do the increasing number thing, you put the formula in one cell and then just drag it's bottom border down to the row you want it to stop at.