Shade Every Other Row
Is there a way to autoformat a spreadsheet ot shade every other row? If so,
I think it would be great if it would stay formatted that way after a sort. thx |
Here's one way:
http://www.andrewsexceltips.com/menu..._colour_even_r ows.htm HTH Jason Atlanta, GA -----Original Message----- Is there a way to autoformat a spreadsheet ot shade every other row? If so, I think it would be great if it would stay formatted that way after a sort. thx . |
Use a conditional format to do this and it will not move when you sort the
rows:- Do CTRL+A, then Format / Conditional Formatting / Change 'cell value is' to 'formula is' and put in =MOD(ROW(),2)=1 Now click on the format button and choose a nice pastel colour from the patterns tab. Hit OK till you are out and you are done. You could also put in =MOD(ROW(),2)=0 if you wanted the other rows to be coloured. You could also put in =MOD(ROW(),3)=0 if you wanted every 3rd row to be coloured. You could also put in =MOD(ROW(),4)=0 if you wanted every 4th row to be coloured. You could also put in =MOD(ROW(),5)=0 if you wanted every 5th row to be coloured. But you probably get the drift by now. Flipping the 1 and the 0 will determine whether or not you start with a coloured or a non-coloured row. If you want to create alternate green bars made up of say 3 rows (or any other color), you can also use: For every three rows: =MOD(ROW()-1,6)<3 For every four rows: =MOD(ROW()-1,8)<4 For other number of shadings, just make the 2nd number (6 or 8 in example) twice as much as the 3rd number (3 or 4 in example) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "danpajo" wrote in message ... Is there a way to autoformat a spreadsheet ot shade every other row? If so, I think it would be great if it would stay formatted that way after a sort. thx |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com