I can't understand why this isn't working for you. You do use ctrl held
whilst clicking on all the rows you need, you can let go of ctrl if you
need to scroll down, though make sure you're holding it before clicking
another row. Once you have all rows selected, right click on any of the
highlighted cells and format as you would.


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=475770