Please can someone advise how I do the following in excel 2010.
I have a row with 10 cells, and 1000 rows altogether.
I would like the whole row to be filled purple if the first cell in the row =2. I can do this individually but dont want to have to do this 1000 times, so tried pasting the format.

when I tried to special paste the format to the other 999 rows I cannot get it to work exactly the same as the range it applies to seems to change.

I'm quite new to excel 2010 so an idiots guide is required

Many thanks

Ben