| Home |
| Search |
| Today's Posts |
|
#1
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
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill series, custom format question | Excel Discussion (Misc queries) | |||
| Can search by cell format like fill color? | Excel Worksheet Functions | |||
| Can I sort Excel sheet by the color of the fill in selected cell | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Sort of format Question | Excel Worksheet Functions | |||
Linear Mode
