|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 18th, 2009, 03:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Fill Format & Sort Question
I have a column with 144 rows. In alternating rows, I have a solid fill to
make the spreadsheet easier to read, especially when printed. However, when I sort one of the columns, the fill formatting changes. Is there a way to sort without changing the fill formats? Thanks! 
|
|
#2
May 18th, 2009, 04:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Fill Format & Sort Question
Use conditional formatting to fill...
Choose the option FORMULA IS and enter the formula =MOD(ROW(),2)=1 or =MOD(ROW(),2)=0 as the condition to format "Scott" wrote: I have a column with 144 rows. In alternating rows, I have a solid fill to make the spreadsheet easier to read, especially when printed. However, when I sort one of the columns, the fill formatting changes. Is there a way to sort without changing the fill formats? Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
