Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
How can I shade columns but keep grid? | Excel Discussion (Misc queries) | |||
Shade alternate lines | Excel Discussion (Misc queries) | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) |